Function of Index_Field
Captures all the index columns used in the query plan.
Index_Field Table Definition
The following CREATE TABLE request defines the Index_Field table:
CREATE TABLE Index_Field( RelationKey INTEGER NOT NULL, IndexNum INTEGER NOT NULL, FieldID INTEGER NOT NULL) PRIMARY INDEX PK_Relationkey_IdxNum(RelationKey, IndexNum) UNIQUE INDEX USK_RelationKey_IdxNum_FieldID (RelationKey, IndexNum, FieldID);
Attribute Definitions for Index_Field
The following table defines the Index_Field table attributes:
| Attribute | Definition |
|---|---|
| RelationKey |
|
| IndexNum |
|
| FieldID |
|