This content has been marked as final. Show 2 replies
PARALLEL is your friend :-)
Make sure to disable parallelism after the index build if you don't want it permanently though.
thanks for your answer. The issue is this is a cOTS product(Siebel Analytics). The indexes are created by DAC(Informatica) automatically. I do not have away to "create index index_name parallel degree 24" clause in there.