Configuration parameters that affect the degree of clustering

The clust field in the sysindexes or the sysindices table represents the degree of clustering of the index. The values of several configuration parameters affect the clust field.

The value of this field is affected by:

Each of these configuration parameters affects the amount of buffer space available for a single user session. Additional buffers can result in better clustering (a smaller clust value in the sysindexes or sysindices tables).

You can create more buffers by performing one or both of the following tasks:

Copyright© 2018 HCL Technologies Limited