SQL Server Gems

Tuesday, August 29, 2006

What kindof statistics does the optimizer in SQL Server 2005 uses?

"Microsoft® SQL Server™ 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data"

Check out
Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

0 Comments:

Post a Comment

<< Home