16.10 - AnalysisStmts - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

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.

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.

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.

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.

AnalysisStmts Related Topics

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

  • IndexRecommendations
  • SeqNumber
  • “INITIATE INDEX ANALYSIS” in SQL Data Manipulation Language
  • “RESTART INDEX ANALYSIS” in SQL Data Manipulation Language