Friday, February 24, 2012

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

No comments:

Post a Comment