first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

SQL Server 2005/2008: “SQL Server UPDATE STATISTICS”

You can add statistics on columns that don't have statistics in order to boost query performance. For example, you can create statistics for columns in a composite index other than the first column (which is the default for AUTO CREATE STATISTICS), and for columns that are not indexed.

The SQL Server Query Optimizer has the ability to use statistics on columns that are not indexed in order to create more optimal execution plans. Doing so can increase performance without having the overhead of indexes. In fact, sometimes it is more efficient to use column statistics instead of an index to optimize query performance. The only way to know this for sure is to make controlled experiments and see what works best for your situation.

[http://www.sql-server-performance.com/tips/update_statistics_p1.aspx]

mod date: 2009-09-16T01:05:25.000Z