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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

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