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:

• The size of the buffer pool as specified by the BUFFERPOOL configuration parameter
• The DS_MAX_QUERIES configuration parameter, which specifies the maximum number of PDQ queries that can run concurrently

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:

• Increasing the size of the buffer pool by updating the value of the BUFFERPOOL configuration parameter
• Decreasing the value of the DS_MAX_QUERIES configuration parameter