autocreate statistics

hi,

my query is really running slow in sql2005... they said i should try turning on the autocreate statistics. where and how do i supposed to do that?

thanks a lot

cherriesh

Use this query:

ALTER DATABASE [MyDataBase]
SET AUTO_UPDATE_STATISTICS ON

Auto update statistics and Auto create statistics options

Recovery Model of the Production Database is FULL.
We have activated the Auto update statistics and Auto
create statistics options. We would like to know
switching off these options, will the size of the
Transaction Log be smaller ?
ThanksNo, these doesn't affect the size of the transaction log. If you have
problem with the size of the transaction log, there are other places to
look. Check out below KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/defaul...kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...kb;en-us;272318
Log File Grows too big
http://www.support.microsoft.com/?id=317375
Log file filling up
http://www.support.microsoft.com/?id=110139
Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=315512
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:9b5501c3eaa8$aae1dcc0$a401280a@.phx.gbl...

quote:

---

> Recovery Model of the Production Database is FULL.
> We have activated the Auto update statistics and Auto
> create statistics options. We would like to know
> switching off these options, will the size of the
> Transaction Log be smaller ?
> Thanks

---