Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    California Coast
    Posts
    72

    Unanswered: index statistics are created when?

    If the auto create stats and auto update stats is off (actually the value is null) at the db level - are stats generated when an index is recreated?

    Additionaly, running the sp_autostats on the above db shows that the auto update stats are on. Where is the option to set it on for an object rather than the db?

    Mike

    I just read by Kalen that if the options are false (off) this overrides the table level. Still not clear on what occurs when options are <null>

    Last edited by wukie; 06-05-03 at 16:44.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True when you run DBCC DBREINDEX those stats will be updated too.

    SP_AUTOSTATS is used to display or change the automatic UPDATE STATISTICS setting for a specific index and statistics, or for all indexes and statistics for a given table or indexed view in the current database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •