15.10 - AnalysisStmts - 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

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