Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1475

Re: Some questions about relational indexes and statistics in SS2005

Show all headers | View raw

 (rja.carnegie@gmail.com) writes:
> Well, my grand scheme includes (1) writing a stored procedure
> that defines, say, ten or twenty indexes and statistics on a 
> table, but allows them to be created one by one, and, 
> (2) using the same interface to perform "index rebuild"
> and "update statistics" on the target - that part isn't 
> done yet.  And this is where the table may be called
> Student_2011, Student_2012, Student_2013, and may be in
> database UserStuff01, UserStuff02, UserStuff03, and so on:
> the interface stored procedure addresses that complexity.
> 
> I also want to avoid having the server do some of this meta-work
> more than once.  Except that it deletes a lot of the data every
> day and loads it in from where it came from again.  So, make that
> "more than necessary".
 
Not sure where you are heading here. Even if you add statistics manually,
SQL Server will still maintain them, just like it maintains autostats.
Or do you plan to turn off automatic updates of statistics for the
database?

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Some questions about relational indexes and statistics in SS2005 rja.carnegie@gmail.com - 2013-05-07 04:39 -0700
  Re: Some questions about relational indexes and statistics in SS2005 Erland Sommarskog <esquel@sommarskog.se> - 2013-05-07 21:26 +0200
    Re: Some questions about relational indexes and statistics in SS2005 rja.carnegie@gmail.com - 2013-05-09 14:45 -0700
      Re: Some questions about relational indexes and statistics in SS2005 Erland Sommarskog <esquel@sommarskog.se> - 2013-05-10 11:05 +0200
        Re: Some questions about relational indexes and statistics in SS2005 rja.carnegie@gmail.com - 2013-05-12 10:01 -0700
          Re: Some questions about relational indexes and statistics in SS2005 Erland Sommarskog <esquel@sommarskog.se> - 2013-05-12 19:22 +0200

csiph-web