I'm just starting to migrate from 9.5 to 9.7 and have started to use the 9.7 features for compression of data and index. I recall having read in the past somewhere that SAP recommended not to compress data/or index for SAP cluster and pool tables, ie these would be the tablespaces called CLU and POOL.
I have heard from an aquaintance that in new (fresh out of the box) SAP on 9.7 implemenations all tables/indexes are automatically (by default) compressed, except of course syscats and MDC's etc. On that note, also that volatile tables are not compressed.
My question:
What are others choosing to do? compress all or "ignore SAP cluster and pool tables"? volatile tables?