最適化ルーチン形式
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