Function of AnalysisLog
Records the log information for index analysis by the Teradata Index Wizard utility.
AnalysisLog maintains the checkpoint information that is recorded when you enable the CHECKPOINT option for an INITIATE INDEX ANALYSIS request.
AnalysisLog Table Definition
The following CREATE TABLE request defines the AnalysisLog table:
CREATE TABLE AnalysisLog ( WorkLoadID INTEGER NOT NULL, RecommendationID INTEGER NOT NULL, IndexNameTag VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL, SeqNumber SMALLINT NOT NULL, Cflag CHARACTER(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, UserName VARCHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL, AnalysisStatus VARBYTE(32000) NOT NULL, StartTime TIMESTAMP(6) NOT NULL, UpdateTime TIMESTAMP(6) NOT NULL) PRIMARY INDEX (WorkloadID, IndexNameTag);
Attribute Definitions for AnalysisLog
The following table defines the AnalysisLog table attributes:
| Attribute | Definition |
|---|---|
| WorkloadID |
|
| RecommendationID | Uniquely identifies the index recommendation generated for the specific index analysis. |
| IndexNameTag |
|
| SeqNumber | A sequence number to identify individual rows that belong to a multirow AnalysisStatus. The sequence begins at 1. |
| Cflag | Used with multirow AnalysisStatus.
|
| UserName | Name of the user performing the index analysis. |
| AnalysisStatus | Identifies the status of the index analysis. This column contains encoded information that the index wizard infrastructure uses. During a checkpoint operation, this information is updated. |
| StartTime | Timestamp for the beginning of the index analysis. |
| UpdateTime | Timestamp for the moment the AnalysisStatus column is most recently updated. |