Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SQL Server collects and maintains statistical information about indexes and column data stored in the database.
SQL Server query optimizer relies on these statistics to choose the most efficient plan for retrieving or updating data. If these statistics are not up-to-date, performance of your queries could be adversely affected.
This whitepaper provides great insights into the world of statistics and how they are used by SQL Server 2005.
You will learn:
- What are statistics and how they are used?
- How SQL Server implements statistics?
- What’s new for Statistics in SQL 2005?
- Creating and maintaining statistics
- Best practices of implementing statistics
You can download this whitepaper from here.
Happy reading!
POSTED BY : Sanchan Saxena
Comments
- Anonymous
May 29, 2009
PingBack from http://paidsurveyshub.info/story.php?title=microsoft-sql-server-support-blog-whitepaper-statistics-used-by-the