Retrieving Data: Indexing

The table below summarizes the Indexing VLDB properties. Additional details about each property, including examples where necessary, are available by clicking on the links in the table.

Property	Description	Possible Values	Default Value
Allow Index on Metric	Determines whether or not to allow the creation of indexes on fact or metric columns.	Don't allow the creation of indexes on metric columns Allow the creation of indexes on metric columns (if the Intermediate Table Index setting is set to create)	Don't allow the creation of indexes on metric columns
Index Post String and Index Qualifier	Defines the string that is appended at the end of the CREATE INDEX statement. For example: IN INDEXSPACE	User-defined	NULL
Retrieving Data: Indexing	Defines the prefix to use when automatically creating indexes for intermediate SQL passes. The prefix is added to the beginning of the CREATE INDEX statement.	User-defined	NULL
Index Post String and Index Qualifier	Defines the string to parse in between the CREATE and INDEX words. For example: CLUSTERED	User-defined	NULL
Intermediate Table Index	Determines whether and when to create an index for the intermediate table.	Don't create an index Create partitioning key (typically applicable to MPP systems) Create partitioning key and secondary index on intermediate table Create only secondary index on intermediate table	Don't create an index
Max Columns in Column Placeholder	Determines the maximum number of columns that replace the column wildcard ("!!!") in pre and post statements. 0 = all columns (no limit).	User-defined	0 (No limit)
Max Columns in Index	Determines the maximum number of columns that can be included in partition key or index.	User-defined	No limit
Primary Index Type	Determines whether a primary key is created instead of a partitioning key for databases that support both types, such as UDB.	Create primary key (where applicable) if the intermediate table index setting is set to create a primary index. Create primary index/partitioning key (where applicable) if the intermediate table index setting is set to create a primary index.	Create primary key (where applicable) if the intermediate table index setting is set to create a primary index.
Secondary Index Order	Defines whether an index is created before or after inserting data into a table.	Create index after inserting into table Create index before inserting into table	Create index after inserting into table
Secondary Index Type	Defines what type of index is created for temporary table column indexing.	Create Composite Index for Temporary Table Column Indexing Create Individual Indexes for Temporary Table Column Indexing	Create Composite Index for Temporary Table Column Indexing