Statistics Used by the Query Optimizer in Microsoft SQL Server 2000

By Bill Graziano on 21 November 2000 | 0 Comments | Tags: Performance Tuning

Describes what data is collected, where it is stored, and which commands create, update, and delete statistics about indexes and column data stored in the Microsoft SQL Server 2000 database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving data and performing INSERT, SELECT, DELETE or UPDATE queries. It also outlines how SQL Server default statistics creation and maintenance settings can be changed on different levels (index, table, and database). Follow the link to Statistics Used by the Query Optimizer in Microsoft SQL Server 2000...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 12,637 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions