15.10 - AnalysisStmts - Teradata Database

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.

The table provides the following information to support generating index recommendations in this scenario:

Identifies a group of logically related INITIATE INDEX ANALYSIS and RESTART INDEX ANALYSIS requests performed as a related sequence.

Provides the sequence number for a given RESTART INDEX ANALYSIS request within the group.

Provides the SQL text for the INITIATE INDEX ANALYSIS or RESTART INDEX ANALYSIS request used to produce a given set of index recommendations.

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

The following table defines the AnalysisStmts table attributes.

Attribute	Definition
WorkLoadID	Uniquely identifies the workload. NUPI for the table.
IndexNameTag	User-specified name for the index analysis.
RecommendationID	Uniquely identifies a set of index recommendations.
IASeqNumber	System‑assigned sequence number for this index analysis.
TimeOfAnalysis	The timestamp of this index analysis
IAStmtText	The SQL text for the request being analyzed.

See the following topics for further information related to the AnalysisStmts table.

“IndexRecommendations” on page 770

“SeqNumber” on page 808

“INITIATE INDEX ANALYSIS” in SQL Data Manipulation Language

“RESTART INDEX ANALYSIS” in SQL Data Manipulation Language