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 attribute | Detailed information about table clustering is provided. |
Expert Sessions (Link to trainings) | Content / Helpful with ... |
|---|---|
| Session 26: SAP MaxDB I/O Concept | Find 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 ... |
|---|---|