Skip to end of metadata
Go to start of metadata

Use

Number of clustered tables: <number>, cluster size: <count>, free clusters: <count>

 

Explanation

Table clustering can influence I/O behaviour as coherent pages can be read with better performance. It is mainly used for BW systems.

 

User Response

Watch if the table clustering is stil helpful to improve the performance or if the tables get defragmented.

 

More Information

Relevant  DB-Analyzer Files
Helpful with ...
DBAN_CLUSTER_IO.csv  
SAP Note
 
1264776 - FAQ: SAP MaxDB OLTP cluster table attributeDetailed information about table clustering is provided.
Expert Sessions (Link to trainings)
Content / Helpful with ...
Session 26: SAP MaxDB I/O ConceptFind a decription which parameters influence the clustering.
Session 9: SAP MaxDB Optimized for SAP Business Warehouse Get more information on how physical table clustering is used in BW systems.
Documentation (Links)
Helpful with ...
  

                            

 

  • No labels