analyze tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: analyze tables

  1. #1
    Join Date
    Jul 2001
    Posts
    181

    analyze tables

    why do you need to analyze tables?

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

  3. #3
    Join Date
    Jul 2002
    Location
    Washington DC
    Posts
    110
    If you don't analyze tables the cost based optimizer to guess what the best optimization is for your queries assuming that there is no data , the CBO will guess poorly in that case. In general, you will see dramatic improvement after analysis if you have never analyzed.

    This is in the case of CBO.

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    To collect or delete statistics about an index or index partition, table or table partition, index-organized table, cluster, or scalar object attribute.

    To validate the structure of an index or index partition, table or table partition, index-organized table, cluster, or object reference (REF).

    To identify migrated and chained rows of a table or cluster.

    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Aug 2002
    Posts
    115
    Does analyzing tables give details of chained rows and the migrating ones?

    Thank you

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    That is wat doc says.
    I quote posted is from oracle doc site....


    generic syntax is

    ANALYZE TABLE table_name
    LIST CHAINED ROWS INTO table_name_u_want_to_have_result;
    Last edited by abhaysk; 03-19-2003 at 07:30 AM.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by aspdba
    Does analyzing tables give details of chained rows and the migrating ones?
    Yea, it does...

    Code:
    analyze table temp list chained rows into chained_rows;
    Check this out for more info...

    http://www.oracle.com/oramag/code/ti...ml?012201.html

    HTH.

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