Indexes
Indexes[=(index-list)]
Noindex
Specifies the index or indexes for which statistics are to be
collected. If you do not specify an index-list, statistics for
all indexes defined for the tables specified with the Tables
qualifier are collected. If you specify an index-list, statistics
are collected only for the named indexes. If you specify
the Noindex qualifier, statistics for the index cardinality,
average index depth, index key clustering factor, and index data
clustering factor are not collected.
Specify the Notable qualifier if you do not want statistics
collected for tables. (Remember, the Tables qualifier without
a table-list is the default.)
The default is the Indexes qualifier without an index-list.