Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference of Alter Index Rebuild and Analyze Index Validate structuture

SmileApr 4 2013 — edited Apr 4 2013
Hello Team ,

After the big search in Google ,
I couldn't understand the difference between
        ALTER INDEX <nm> REBUILD ONLINE 
       
AND
       ANALYZE INDEX <nm> VALIDATE STRUCTURE 
       
Could you please give me brief information .

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2013
Added on Apr 4 2013
3 comments
891 views