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