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.