IndexRecommendations - Advanced SQL Engine - Teradata Database

IndexRecommendationsの機能

INITIATE INDEX ANALYSISによって生成されたインデックスの推奨事項に関する情報が含まれています。

IndexRecommendationsは、後で取得できるように、インデックス分析中に指定されたオプションを記録します。

IndexRecommendationsテーブルの定義

次のCREATE TABLEリクエストは、IndexRecommendationsテーブルを定義しています。

   CREATE TABLE IndexRecommendations(
     WorkLoadID          INTEGER NOT NULL,
     UserName            VARCHAR128 CHARACTER SET UNICODE
                         NOT CASESPECIFIC NOT NULL,
     TimeOfAnalysis      TIMESTAMP(0) NOT NULL,
     RecommendationID    INTEGER NOT NULL,
     QueryID             INTEGER NOT NULL,
     IndexID             INTEGER,
     IndexNameTag        VARCHAR128 CHARACTER SET UNICODE
                         NOT CASESPECIFIC NOT NULL,
     TableName           VARCHAR128 CHARACTER SET UNICODE
                         NOT CASESPECIFIC NOT NULL,
     DatabaseName        VARCHAR128 CHARACTER SET UNICODE
                         NOT CASESPECIFIC NOT NULL,
     TableID             BYTE(6) NOT NULL,
     IndexType           INTEGER,
     IndexTypeText       VARCHAR(30) CHARACTER SET LATIN
                         NOT CASESPECIFIC,
     StatisticsInfo      VARBYTE(16383),
     OriginalCost        FLOAT,
     NewCost             FLOAT,
     SpaceEstimate       FLOAT,
     TimeEstimate        FLOAT,
     DropFlag            CHARACTER(1)CHARACTER SET LATIN
                         NOT CASESPECIFIC,
     IndexDDL            VARCHAR(10000) CHARACTER SET UNICODE
                         NOT CASESPECIFIC,
     StatsDDL            VARCHAR(10000) CHARACTER SET UNICODE
                         NOT CASESPECIFIC,
     Remarks             VARCHAR(1024) CHARACTER SET UNICODE
                         NOT CASESPECIFIC,
     AnalysisData        VARCHAR(2048) CHARACTER SET LATIN
                         NOT CASESPECIFIC,
     IndexesPerTable     SMALLINT DEFAULT NULL,
     SearchSpaceSize     SMALLINT,
     ChangeRateThreshold BYTEINT,
     ColumnPerIndex      SMALLINT,
     ColumnsPerJoinIndex SMALLINT DEFAULT NULL,
     IndexMaintMode      BYTEINT DEFAULT NULL,
     JINumber            INTEGER DEFAULT NULL,
     JITableName         VARCHAR128 CHARACTER SET UNICODE
                         NOT CASESPECIFIC DEFAULT NULL,
     TimeLimitExceeded   CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC)
     TimeLimit           INTEGER
   PRIMARY INDEX (WorkloadID);

IndexRecommendationsの属性の定義

次のテーブルは、IndexRecommendationsテーブル属性を定義しています。