AnalysisStmts - Advanced SQL Engine - Teradata Database

Function of AnalysisStmts

Supports combined use of the CHECKPOINT and TIMELIMIT options for the INITIATE INDEX ANALYSIS and RESTART INDEX ANALYSIS statements, particularly in the context of submitting an INITIATE INDEX ANALYSIS request that is halted for some reason, followed by one or more RESTART INDEX ANALYSIS requests.

AnalysisStmts Table Definition

The following CREATE TABLE request defines the AnalysisStmts table:

CREATE SET TABLE QCD.AnalysisStmts, NO FALLBACK, NO BEFORE JOURNAL,
                                         NO AFTER JOURNAL,
                                         CHECKSUM=DEFAULT
                                         DEFAULT MERGEBLOCKRATIO(
       WorkLoadID       INTEGER NOT NULL,
       IndexNameTag     VARCHAR(128) CHARACTER SET UNICODE
                        NOT CASESPECIFIC NOT NULL,
       RecommendationID INTEGER NOT NULL,
       IASeqNumber      INTEGER NOT NULL,        TimeOfAnalysis   TIMESTAMP(6) NOT NULL,
       IAStmtText       VARCHAR(20000) CHARACTER SET UNICODE
                        NOT CASESPECIFIC)
     PRIMARY INDEX (WorkLoadID);

Attribute Definitions for AnalysisStmts

The following table defines the AnalysisStmts table attributes.

AnalysisStmts Related Topics