DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: schema stats

  1. #1
    Join Date
    Apr 2013
    Location
    HeLl
    Posts
    1

    schema stats

    which is more beneficial schema stats or table stats or database stats?
    and when a query is fired optimizer looks for what stats table stats or schema stats to execute the query?
    what is the first stats preference of optimizer??

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    All stats are necessary, optimizer looks at all, but most critical are the schema (all table/index) stats.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

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


Click Here to Expand Forum to Full Width