You get to the Statistics page from the Database Overview Page or from the hierarchy tree.


What are Statistics

Statistics sample your data and are use by the query optimizer to determine the best way to execute your query.
If statistics are out of date, your queries may not be using the best process to get to data.


Example: Statistics Gone Wrong

  1. Table created in a test environment
  2. Add indexes as needed
  3. Deploy to a production system (no autostatistics)
  4. Table starts out small in production
  5. Generate statistics (once)
  6. Table grows BIG over the next 4 years, with no new statistics
  7. Query optimizer still thinks your table is small, and you get the wrong plan.

Leave a Reply

Your email address will not be published. Required fields are marked *