16.10 - AnalysisLog - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

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
  • Uniquely identifies the workload.
  • Partial NUPI for the table.
RecommendationID Uniquely identifies the index recommendation generated for the specific index analysis.
IndexNameTag
  • User-specified name for the index analysis.
  • Partial NUPI for the table.
SeqNumber A sequence number to identify individual rows that belong to a multirow AnalysisStatus.

The sequence begins at 1.

Cflag Used with multirow AnalysisStatus.
  • If the row is the last row in the sequence, then Cflag is set to F.
  • If the row is not the last row in the sequence, then Cflag is set to T.
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.