SHOW STATISTICS Syntax | Teradata Vantage - SHOW STATISTICS Syntax - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Optimizer Form

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 Form

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