17.10 - AnalysisLog - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

Function of AnalysisLog

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.
StartTime Timestamp for the beginning of the index analysis.
UpdateTime Timestamp for the moment the AnalysisStatus column is most recently updated.