ABAP table declustering /depooling for all tables - Enable or disable?

[former_member201054]

Hi Experts,

Which option needs to be selected for NW 7.45 database installation in MCOD oracle 12.0. DB is already built , just installing the schema.

a) Enabling declustering/depooling of all ABAP tables

b) Dont decluster / depool ABAP tables.

either a) or b)?..what is the difference

I would appreciate all your help.

Thanks in advance

[manoj2910]

Hi,

As per Note 1892354

Cluster and pool tables have been introduced by SAP in early releases to efficiently store information from several application tables in one database table.Cluster tables combine information from several tables logically belonging together. They allow efficient access to a whole application object without incurring joins on database level.Pool tables combine a large number of individual small tables into one database table, which addressed problems with large numbers of individual database objects.For both types, table data is compressed by the SAP kernel, which does the translation between the logical table structure as seen by the application and the compressed storage structure in the database. Because the data is encoded in a proprietary format, the data can only be accessed by the SAP kernel and no calculations can be performed on database level.Today, most of the considerations that originally led to the design of these concepts are obsolete. In addition, the missing ability to perform calculations on pool and cluster tables on database level causes problems for optimization scenarios. Therefore, the transition to transparent database tables is necessary in order to allow this type of optimizations.

SAP HANA systems are de-clustered and de-pooled per default. For this reason, there is no change needed for customers using SAP HANA.

Hope this helps

Regards,

Manoj