'Usp update stats' presentation slideshows

INTELLIGENT STATISTICS UPDATE

For most of the application databases, sp_updatestats does a good job of updating the statistics to give a good enough performance. However, sp_updatestats scans only a default sample of rows to arrive at statistics, which can be skewed if there is wide variation of data values with the tables and may not be enough for some applications to generate optimal query plans.

36 views • 2 slides