且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

请教关于ANALYZE 命令的一些疑惑

更新时间:2022-03-01 09:13:53

摘自:http://www.itpub.net/410314.html

FOR TABLE Specify FOR TABLE to restrict the statistics collected to only table
statistics rather than table and column statistics.
FOR COLUMNS Specify FOR COLUMNS to restrict the statistics collected to only
column statistics for the specified columns and scalar object attributes, rather than
for all columns and attributes; attribute specifies the qualified column name of
an item in an object.
FOR ALL COLUMNS Specify FOR ALL COLUMNS to collect column statistics for all
columns and scalar object attributes.
FOR ALL INDEXED COLUMNS Specify FOR ALL INDEXED COLUMNS to collect
column statistics for all indexed columns in the table.
FOR ALL INDEXES Specify FOR ALL INDEXES if you want all indexes associated
with the table to be analyzed.