Results 1 to 2 of 2

Thread: analyze table

  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: analyze table

    Hi,

    The below query is used for optimization. The query execution plan will make use of the statistics created. Is that the satistics created for all the columns in the table (OR) only for the indexed columns. Statistics created ? What it is actually meant ? What it does for statistics creation ?

    Please explain the below query :

    analyze table test estimate statistics sample 2500 Rows;

    Thanks,
    Sam

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    To get a full understanding, read the Gathering Optimizer Statistics chapter of the Performance Tuning Guide.

Posting Permissions

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