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!

analyse index xxx validate structure on a lage table

tahaJun 6 2011 — edited Jun 6 2011

Hi,

i am trying to find a way to verify that some indexes (5) in a large table (20 millions rows) do/don't need to be rebuild, i found that i can use the analyse index xxx validate structure but the problem is that articles are saying that this method (may slow down the transactions worse lock the table ... :()
is there a nicer way to have stats on my indexes without affecting the DML transactions !!!

thanks
Taha

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2011

Added on Jun 6 2011

#general-database-discussions

3 comments

564 views