Statistics Used by the Query Optimizer in Microsoft SQL Server 2000

By Bill Graziano on 21 November 2000 | 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).

Link: Statistics Used by the Query Optimizer in Microsoft SQL Server 2000

Related Articles

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

SQL Server Storage Engine Team Blog (7 June 2006)

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 (1 June 2005)

Improving .NET Application Performance and Scalability (29 April 2004)

Other Recent Forum Posts

Use a C# SQLReader to input an SQL hierarchyid (2h)

Translate into easier query/more understandable (7h)

Aggregation view with Min and Max (17h)

Data file is Compressed - Cannot Re-Attach, Cannot Restore (19h)

Sql trigger assign value to parameter (4d)

Need a sales $ for the past 90 days (4d)

Could you please help me understand recursive queries in SQL? I have been stuck for one week trying to debug (4d)

VS2022, SSIS Excel import (5d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site