MicroStrategy ONE

Max Columns in Index

The Max Columns in Index property controls the maximum number of columns that can be used when creating an index. This limit applies to both primary and secondary indexes. If the maximum is five columns but there are 10 columns available to index, the first five are selected. However, each attribute has a "weight" that you can set. When SQL is generated, the attributes are selected in ascending order of "weight." By combining Attribute Weights and the Max Columns in Index properties, you can designate any attribute to be included in the index.

You can define attribute weights in the Project Configuration Editor. Select the Report definition: SQL generation category, and in the Attribute weights section, click Modify.

The table below explains the possible values and their behavior:

Value Behavior

0

All attribute ID columns are placed in the index

Number

The maximum number of attribute ID columns that are placed in the index

Levels at Which You Can Set This

Database instance, report, and template