Page History
...
Stores snapshots of the index keys. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
| Column |
|---|
...
| Name | Column |
|---|
...
| Description | |
|---|---|
SQCK_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCK_DATABASE_ID | Internal ID of the database. |
SQCK_OBJECT_ID | ID of the object on which the index is defined |
...
| . | |
SQCK_INDEX_ID | ID of the index. |
SQCK_COLUMN_ID | ID of the column. |
SQCK_COLUMN_NAME | Name of the column key. |
SQCK_INDEX_NAME | Name of the index. |
SQCK_OBJECT_NAME | Name of the table. |
SQCK_OBJECT_OWNER | Owner of the table. |
SQCK_POSITION | Position of the key in the index. |
SQCK_ORDER_BY | Sorting of the key in the index. |
PW_SQCI_SCHEMA_CHANGES_INDEXES
Stores snapshots of the indexes. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
| Column Name | Column Description |
|---|---|
SQCI_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCI_DATABASE_ID | Internal ID of the database. |
SQCI_OBJECT_ID | ID of the object on which the index is defined. |
SQCI_INDEX_ID | ID of the index. |
SQCI_INDEX_NAME | Name of the index. |
SQCI_OBJECT_NAME | Name of the table. |
SQCI_OBJECT_OWNER | Owner of the table. |
SQCI_FILE_GROUP | File group in which the index resides. |
SQCI_NUM_OF_KEYS | Number of keys in the index. |
SQCI_FILL_FACTOR | Fill factor of the index. |
SQCI_IS_CLUSTERED_INDEX | Indicates whether the index is clustered. |
SQCI_IS_PAD_INDEX | Indicates whether the index is padded. |
SQCI_IS_UNIQUE | Indicates whether the index is unique. |
SQCI_INDEX_DEPTH | Index tree level. |
SQCI_IS_AUTH_STAT | Indicates if the index has turned on the autostatistics. |
SQCI_IS_PAGE_LOCK_DISALLOWED | Indicates whether an index page can be locked. |
SQCI_IS_ROW_LOCK_DISALLOWED | Indicates whether an index row can be locked. |