Troubleshooting Statistics

Here are some problems you may encounter when using statistics:

• When a table has a large number of indexes, and statistics are being either created or updated, you may receive this error:

Cannot create more than 250 indexes on a table.

• Columns larger than 900 bytes cannot have statistics created on them.
• Verify that the query is using indexes by viewing the showplan output.
• Indexes are ignored. Verify the statistics information by executing DBCC SHOW_STATISTICS.
• Verify that there are no distribution page references in sysindexes.