17.10 - SHOW STATISTICS構文 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
プログラミング リファレンス
Publication ID
B035-1144-171K-JPN
Language
日本語 (日本)

最適化ルーチン形式

SHOW [IN XML] [SUMMARY] [CURRENT] { STATISTICS | STATS | STAT }
  [ VALUES [SEQUENCED] ]
  { [ UNIQUE ] INDEX index_name |

    [ UNIQUE ] INDEX [ index_name ] [ALL] ( column_name_1 [,...] )
      [ ORDER BY { VALUES | HASH } ( column_name_2 ) ] |

    COLUMN column_specification
  }
  ON table_specification [;]
column_specification
{ { expression | ( expression [,...] ) } AS statistics_name |

  { statistics_name |
    column_name |
    PARTITION |
    ( { column_name | PARTITION } [,...] )
  } [ [AS] statistics_name ]
}
table_specification
{ [TEMPORARY] [ database_name. | user_name. ] table_name_1 |

  [ database_name. | database_name. ] { join_index_name | hash_index_name }
}

QCD形式

SHOW [IN XML] { STATISTICS | STATS | STAT }
  [ VALUES [ SEQUENCED ] ]
  { [ UNIQUE ] INDEX index_name |

    [ UNIQUE ] INDEX [ index_name ] [ALL] ( column_name_1 [,...] )
      [ ORDER BY { VALUES | HASH } ( column_name_2 ) ] |

     COLUMN column_specification
   }
   ON table_specification
   [ FOR QUERY query_id ]
   [ SAMPLEID statistics_id ]
   [ USING MODIFIED ] [;]
column_specification
{ statistics_name |
  column_name |
  PARTITION |
  ( { column_name | PARTITION } [,...] )
} [ [AS] statistics_name ]
table_specification
[ database_name. | user_name. ]
  { table_name_1 | join_index_name | hash_index_name } FROM qcd_name