|
Home > Archive > MS SQL Server > January 2006 > Create Statistics Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Create Statistics Question
|
|
| Amos Soma 2006-01-30, 8:23 pm |
| I have a 2005 database with Auto Create Statistics set to true and Auto
Update Statistics set to true. Am I correct that it should not be necessary
for me to manually execute any 'Create Statistics' statements to create
statistics to help in query plan generation? My assumption is that with
these two statements set to true, SQL 2005 will create whatever statistics
it needs, and I don't need to create any.
Thanks, Amos.
| |
| Andrew J. Kelly 2006-01-30, 8:23 pm |
| There may be some exceptions but in general that is true.
--
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@yahoo.com> wrote in message
news:ucZp4neJGHA.740@TK2MSFTNGP12.phx.gbl...
>I have a 2005 database with Auto Create Statistics set to true and Auto
>Update Statistics set to true. Am I correct that it should not be necessary
>for me to manually execute any 'Create Statistics' statements to create
>statistics to help in query plan generation? My assumption is that with
>these two statements set to true, SQL 2005 will create whatever statistics
>it needs, and I don't need to create any.
>
> Thanks, Amos.
>
|
|
|
|
|