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!

"analyze index" vs "rebuild index"

373353May 19 2004 — edited Jan 1 2006

Hi,
I don't undestand the difference between "analyze index" and "rebuild index".

I have a table where I do a lot of "insert" and "update" and "query", What is the best thing to do ??

thanks

Giordano

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 29 2006

Added on May 19 2004

#general-database-discussions

10 comments

40,547 views