Function of IndexColumns
Captures the columns that form the index identified by IndexID during index analysis using INITIATE INDEX ANALYSIS.
IndexColumns Table Definition
The following CREATE TABLE request defines the IndexColumns table:
CREATE TABLE IndexColumns( WorkLoadID INTEGER NOT NULL, RecommendationID INTEGER NOT NULL, TableID BYTE(6) NOT NULL, IndexID INTEGER NOT NULL, ColumnName VARCHAR128 CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL) PRIMARY INDEX ( RecommendationID, TableID, IndexID );
Attribute Definitions for IndexColumns
The following table defines the IndexColumns table attributes:
| Attribute | Definition |
|---|---|
| WorkloadID | Uniquely identifies the workload analyzed to create this secondary index recommendation. |
| RecommendationID |
|
| TableID |
|
| IndexID |
|
| ColumnName | The name of the column in the index. The number of rows in IndexColumns for a given index is equal to the number of columns in the index, so any composite index has multiple rows associated with it. |