Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Create Statistics reccommended by DB tuning wizard

Author  Topic 

bushfoot
Yak Posting Veteran

53 Posts

Posted - 2009-04-07 : 14:10:49
I ran a sql profile trace file through the sql 2008 db tuning wizard. It has reccommended Create Statistics.

Can anyone explain what benefits come from statistics
How does it affect how procs are run
How do they differ to indexes
Is there an equivalent index for a statistics

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-07 : 14:12:01
This information is discussed in the SQL Server documentation, Books Online. Have a look in there and then if you have any questions that aren't answered or if it's too complex, let us know.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -