Query - Advanced SQL Engine - Teradata Database

Queryの機能

獲得された問合わせに関する情報を記述します。

Queryテーブルの定義

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

CREATE TABLE Query(
  QueryID                   INTEGER NOT NULL,
  UDB_Key                   INTEGER NOT NULL,
  MachName                  VARCHAR(30) CHARACTER SET UNICODE
                            NOT CASESPECIFIC NOT NULL,
  NumAMPs                   INTEGER NOT NULL,
  NumPEs                    INTEGER NOT NULL,
  NumNodes                  INTEGER NOT NULL,
  ReleaseInfo               VARCHAR(256) CHARACTER SET UNICODE
                            NOT CASESPECIFIC NOT NULL,
  VersionInfo               VARCHAR(256) CHARACTER SET UNICODE
                            NOT CASESPECIFIC NOT NULL,
  PENum                     INTEGER NOT NULL,
  QueryText                 VARCHAR(20000) CHARACTER SET UNICODE
                            NOT CASESPECIFIC,
  CaptureTimeStamp          TIMESTAMP(0) NOT NULL,
  QueryName                 VARCHAR128 CHARACTER SET UNICODE
                            NOT CASESPECIFIC,
  Frequency                 INTEGER NOT NULL,
  StatementTypes            VARCHAR(120) CHARACTER SET LATIN
                            NOT CASESPECIFIC NOT NULL,
  DefaultDBName             VARCHAR128 CHARACTER SET UNICODE
                            NOT CASESPECIFIC NOT NULL,
  Overflow                  CHARACTER(1) CHARACTER SET LATIN,
                            NOT CASESPECIFIC,
  Complete                  CHARACTER(1) CHARACTER SET LATIN,
                            NOT CASESPECIFIC,
  ValidatedPlan             CHARACTER(1) CHARACTER SET LATIN,
                            NOT CASESPECIFIC,
  ImportedPlan              CHARACTER(1) CHARACTER SET LATIN,
                            NOT CASESPECIFIC,
  SessionTemporalQualifier  VARCHAR(1024) CHARACTER SET LATIN
                            NOT CASESPECIFIC,
  TemporalTimestamp         TIMESTAMP(0),
  TotalCost                 FLOAT DEFAULT 0),
UNIQUE PRIMARY INDEX PK_QueryID (QueryID);

Queryの属性の定義

次のテーブルは、クエリー テーブル属性を定義します。