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.10
Published
July 2021
ft:locale
en-US
ft:lastEdition
2021-07-27
dita:mapPath
spp1591731285373.ditamap
dita:ditavalPath
spp1591731285373.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