Analyze Index and Data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Analyze Index and Data

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello:

    Analyze Data and Analyze Index are 2 different things right?

    What I mean is:

    Say I have segment type table with 3GB and segment type index with 5GB. When I say analyze table "table_name" I am only analyzing table and not index data right. Should I also analyze indexes seperately? How would I do that?

    Thanks, ST2000

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    i have learnt from one of the postings that analyze table "table_name" compute statistics will do for both table data and indexes
    siva prakash
    DBA

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    If you have the DBMS_STATS package available on your version of Oracle then you should be using that. It is faster (it can be parallellized) and in some cases more accurate.

    Other than that, if you make sure always to specify one or more of the following FOR clauses then you will always be sure what is going on ...

    ... for table
    ... for all indexes
    ... for all indexed columns

    eg. analyze table my_table compute statistics for table for all indexed columns for all indexes;

    see SQL reference for complete syntax.

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