Statistics Creation on SQL 2005
in [Server Configuration]
|
From: Henrik Staun Poulsen on 4 May 2010 04:01 RG, I would like to recommend the book: http://www.amazon.com/Relational-Database-Index-Design-Optimizers/dp/0471719994 by Tapio Lahdenmaki and Mike Leach. Best regards, Henrik Staun Poulsen www.stovi.com On May 3, 2:43 pm, "RG" <nob...(a)nowhere.com> wrote: > Ah.. So, stats could go on indexes or columns. I thought that stats only > go on indexes' underlying columns. Would it be correct to say that for low > cardinality columns used in queries, you would want create statistics on > columns and not to create index? > > Is there a reason why sql server allows duplicate statistics for the same > column(s)? > > Thanks for your help"RG" <nob...(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" <guzma...(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" <R...(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- Hide quoted text - > > - Show quoted text - |