Results 1 to 2 of 2

Thread: index rebuild

  1. #1
    Join Date
    Apr 2003
    Posts
    17

    Unanswered: index rebuild

    I have an index named idx_1 which i want to rebuilding.
    First I used the query "Select * from dba_indexes where index_name='idx_1'; ". It returned blank row. Then I gave these 2 stms "Analyze index idx_1 compute statistics; Analyze index idx_1 validate structure; ". After that I again checked the status in dba_indexes where the row was now populated. After that I gave the cmd to rebuild "Alter index idx_1 rebuild". Now when I checked the status in dba_indexes the row returned the same values before rebuilding. Why so. Who will I know that the index is rebuild.

    What is the purpose of Analyze compute statistics & Analyze validate structure here.

  2. #2
    Join Date
    Apr 2003
    Location
    Germany
    Posts
    25
    Hi, as i know rebuild the index does even not change the last_ddl_time in dba_objcts.
    So the CBO will recognize the changes after an analyze of the index.

    There is an addiotional table ( i think index_stats ) this will be filled after a validate, to know how lazy your indxex is and if it's time to rebuild it.
    HTH
    Orca

Posting Permissions

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