15.10 - AnalysisLog - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

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.

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);

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.