question

Rob Farley avatar image
Rob Farley asked

Information in index system views with auto update statistics turned off

We know that the system views hold good information about indexes. But if the system isn't set to automatically update statistics, can we trust the information in there, such as the number of rows in an index, etc?

PS: If you're reading this, then I encourage you to come with a good seeder question and post it too! Without good questions, the site will never catch on as a useful resource.

sql-serverindexingstatisticsseeder-questiondynamic-management-view
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image Rob Farley commented ·
I wanted to make a tag for statistics, but didn't have enough points... Thanks for retagging.
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered

If the system is not updating the statistics automatically and you're not running a manual process to get the statistics updated, then no, you can't trust them. What's more, you can't trust the execution plans that running against your system to return your data because those execution plans are completely dependent on the stats being up to date and accurate.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.