Oracle Database Discussions

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!

reindex and analyze

LEARNING_ORACLEOct 3 2007 — edited Oct 3 2007

Hi,

One of the requirement is telling reindex and analyze.

My understanding of reindex is recreating the inefficent index and sometime rebuild index also.

Analyze ? Gathering of stats or what ?

Regards
MMU

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2007

Added on Oct 3 2007

#general-database-discussions

3 comments

1,056 views