Tag Archives: sql server 2008 r2 Statistics

How to check Database Statistics are optimized for Performance ?

What is Statistics in SQL Server ? Statistics helps Query Optimizer to makes a decision to choose the fast good (best) way to execute a given query. Statistics decides, whether to choose  a particular index or not and build the execution plan. So if your stats are not updated then Optimizer might not choose the [...]