Results 1 to 3 of 3

Thread: analyze

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: analyze

    Hi all,

    What is the need of analyze statement?What happens when dba issue analyze statement?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: analyze

    It's all about gathering statistics to help the optimizer - e.g. number of records in a table, number of blocks used by table, ...

    For full details read the Performance Tuning Guide

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    do this as a test/investigation:

    analyze your whole schema.

    then export this schema and import somewhere else (not-analyzed as a default when you import).

    Now run traces for queries on both schemas.

    You will notice a great difference is how the optimizer behaves.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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