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.

more ▼

asked Oct 21, 2009 at 10:56 PM in Default

avatar image

Rob Farley
5.8k 16 22 28

I wanted to make a tag for statistics, but didn't have enough points... Thanks for retagging.

Oct 22, 2009 at 08:55 AM Rob Farley
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 22, 2009 at 08:05 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 21, 2009 at 10:56 PM

Seen: 1776 times

Last Updated: Apr 15, 2010 at 05:36 AM

Copyright 2016 Redgate Software. Privacy Policy