oracle indexes to be executed in parallel

Question

Hi,

In oracle, Can i run index rebuild in parallel , all indexes belonging to same table.

We have a dyanmic sql procedure for rebuilding indexes, so can call that procedure in parallel for 3 indexes belonging to same table.

Regards, Shi

Answer 1

Hi,

I think it should cause no problems, you might want to check if the columns of the index overlap or not.

refer this for more info:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2913600659112

Thanks