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

    Unanswered: auto_create & update statistics is null

    Does this have the effect of not creating any statistics for the db and therefore forces queries to FTS rather than use an index?

    How can I tell if stats exist for the tables/indexes?

    Thanks,
    Mike

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Better to leave the option as it is by default, and also make sure to run SP_UPDATESTATS to update statistics and also generate DBCC checks to keep up the performance.

    Use SP_HELPSTATS to return the information on stats.
    --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
  •