|
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.
(comments are locked)
|
|
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. Your queries should still work, just not so likely to use the ideal plan. Once the plan is decided upon, the system will still go to the data, even though it doesn't know how that data is distributed.
Oct 22 '09 at 08:53 AM
Rob Farley
Right. The queries will return data, and the correct data too. But the queries will in all likelihood perform very badly because the execution plans will be so out of wack due to the lack of statistics.
Oct 22 '09 at 08:49 PM
Grant Fritchey ♦♦
(comments are locked)
|
I wanted to make a tag for statistics, but didn't have enough points... Thanks for retagging.