Statistics Creation on SQL 2005
in [Server Configuration]
|
From: RG on 30 Apr 2010 09:07 My db has "auto create statistics" on. For some reason, there are quite a few indexes that don't have statistics. What could be the cause? Thanks in advance
From: RG on 30 Apr 2010 09:15 Sorry about the bother. I got my answer. "auto create statistics" proces only creates statistics if columns are found in where clause. "RG" wrote: > My db has "auto create statistics" on. For some reason, there are quite a > few indexes that don't have statistics. > > What could be the cause? > > Thanks in advance
From: Dan Guzman on 1 May 2010 08:10 > My db has "auto create statistics" on. For some reason, there are quite a > few indexes that don't have statistics. Indexes automatically include statistics (including those that support primary key and unique constraints) so you don't need to separately create stats. -- Hope this helps. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/ "RG" <RG(a)discussions.microsoft.com> wrote in message news:B2336A67-BED5-447D-817F-9FDCEFC7887D(a)microsoft.com... > My db has "auto create statistics" on. For some reason, there are quite a > few indexes that don't have statistics. > > What could be the cause? > > Thanks in advance
From: RG on 2 May 2010 17:52 I am confused. Why, then, after doing reindex, there were no statistics for certain index columns.? Thanks for your help. "Dan Guzman" <guzmanda(a)nospam-online.sbcglobal.net> wrote in message news:4C348B2D-2EA1-4C99-8147-A32FBAF1D949(a)microsoft.com... >> My db has "auto create statistics" on. For some reason, there are quite >> a >> few indexes that don't have statistics. > > Indexes automatically include statistics (including those that support > primary key and unique constraints) so you don't need to separately create > stats. > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > http://weblogs.sqlteam.com/dang/ > > "RG" <RG(a)discussions.microsoft.com> wrote in message > news:B2336A67-BED5-447D-817F-9FDCEFC7887D(a)microsoft.com... >> My db has "auto create statistics" on. For some reason, there are quite >> a >> few indexes that don't have statistics. >> >> What could be the cause? >> >> Thanks in advance >
From: Kalen Delaney on 3 May 2010 07:42
What makes you think there were no statistics? Did you run DBCC SHOW_STATISTICS? Note that sp_helpstats only shows column statistics, not index statistics. -- HTH Kalen ---------------------------------------- Kalen Delaney SQL Server MVP www.SQLServerInternals.com "RG" <nobody(a)nowhere.com> wrote in message news:B0AEB0A2-1511-4BBF-9F05-65A26A043964(a)microsoft.com... > I am confused. Why, then, after doing reindex, there were no statistics > for certain index columns.? > > Thanks for your help. > "Dan Guzman" <guzmanda(a)nospam-online.sbcglobal.net> wrote in message > news:4C348B2D-2EA1-4C99-8147-A32FBAF1D949(a)microsoft.com... >>> My db has "auto create statistics" on. For some reason, there are quite >>> a >>> few indexes that don't have statistics. >> >> Indexes automatically include statistics (including those that support >> primary key and unique constraints) so you don't need to separately >> create stats. >> >> -- >> Hope this helps. >> >> Dan Guzman >> SQL Server MVP >> http://weblogs.sqlteam.com/dang/ >> >> "RG" <RG(a)discussions.microsoft.com> wrote in message >> news:B2336A67-BED5-447D-817F-9FDCEFC7887D(a)microsoft.com... >>> My db has "auto create statistics" on. For some reason, there are quite >>> a >>> few indexes that don't have statistics. >>> >>> What could be the cause? >>> >>> Thanks in advance >> > |