Optimizer on SQL 2005
in [Server Configuration]
|
Prev: Can't set up new user in Sql 2000
Next: Using LIKE..
From: RG on 2 Feb 2010 23:52 I ran dbcc updateusage ('demodb'). I than ran dbcc show_statistics ('location', 'ix_phone'). The update date (statistics update date) remained old. Why? Why weren't statistics updated? BTW.. I have auto update statistics set to on. Thanks in advance
From: Tibor Karaszi on 3 Feb 2010 01:19 DBCC UPDATEUSAGE doesn't update statistics. It only updates the info SQL Server keeps about number of rows, pages and such. To update statistics you use the UPDATE STATISTICS command. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "RG" <nobody(a)nowhere.com> wrote in message news:10D6EDAA-DB6E-452B-BD08-966328F5F384(a)microsoft.com... > I ran dbcc updateusage ('demodb'). > > I than ran dbcc show_statistics ('location', 'ix_phone'). The update date > (statistics update date) remained old. Why? Why weren't statistics > updated? > > BTW.. I have auto update statistics set to on. > > Thanks in advance
From: Kalen Delaney on 3 Feb 2010 01:19 dbcc updateusage does not update the distribution statistics, but rather the row and page count information. To update distributions statistics, run UPDATE STATISTICS. -- HTH Kalen ---------------------------------------- Kalen Delaney SQL Server MVP www.SQLServerInternals.com "RG" <nobody(a)nowhere.com> wrote in message news:10D6EDAA-DB6E-452B-BD08-966328F5F384(a)microsoft.com... > I ran dbcc updateusage ('demodb'). > > I than ran dbcc show_statistics ('location', 'ix_phone'). The update date > (statistics update date) remained old. Why? Why weren't statistics > updated? > > BTW.. I have auto update statistics set to on. > > Thanks in advance
From: Tibor Karaszi on 3 Feb 2010 02:32 We posted the reply same minute and pretty close the same information. :-) -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Kalen Delaney" <please_reply_on_newsgroups(a)domain.com> wrote in message news:5FA1FAB4-BC24-47A6-81FB-A729576B3365(a)microsoft.com... > dbcc updateusage does not update the distribution statistics, but rather > the row and page count information. To update distributions statistics, > run UPDATE STATISTICS. > > -- > HTH > Kalen > ---------------------------------------- > Kalen Delaney > SQL Server MVP > www.SQLServerInternals.com > > "RG" <nobody(a)nowhere.com> wrote in message > news:10D6EDAA-DB6E-452B-BD08-966328F5F384(a)microsoft.com... >> I ran dbcc updateusage ('demodb'). >> >> I than ran dbcc show_statistics ('location', 'ix_phone'). The update >> date (statistics update date) remained old. Why? Why weren't statistics >> updated? >> >> BTW.. I have auto update statistics set to on. >> >> Thanks in advance >
From: Jay on 3 Feb 2010 02:45
Tibor and Kalen, sitting in a tree, ... :) "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in message news:u8hKxLKpKHA.1892(a)TK2MSFTNGP02.phx.gbl... > We posted the reply same minute and pretty close the same information. :-) > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > > "Kalen Delaney" <please_reply_on_newsgroups(a)domain.com> wrote in message > news:5FA1FAB4-BC24-47A6-81FB-A729576B3365(a)microsoft.com... >> dbcc updateusage does not update the distribution statistics, but rather >> the row and page count information. To update distributions statistics, >> run UPDATE STATISTICS. >> >> -- >> HTH >> Kalen >> ---------------------------------------- >> Kalen Delaney >> SQL Server MVP >> www.SQLServerInternals.com >> >> "RG" <nobody(a)nowhere.com> wrote in message >> news:10D6EDAA-DB6E-452B-BD08-966328F5F384(a)microsoft.com... >>> I ran dbcc updateusage ('demodb'). >>> >>> I than ran dbcc show_statistics ('location', 'ix_phone'). The update >>> date (statistics update date) remained old. Why? Why weren't >>> statistics updated? >>> >>> BTW.. I have auto update statistics set to on. >>> >>> Thanks in advance >> |