About Oracle rebuild index by using parallel_clause to speed up
Greetings All, Generally, we can use parallel_clause to speed up for rebuilding index in both partition index and global index.
After rebuilt, as indexing is IO intensive, we'll have lots of times where we are waiting on IO and not
using the CPU, so that we should change parallel_clause to Noparallel by alter index... noparallel, but it just can be perform in global index.
My question is that is there any way to change the partition index to noparallel after we use parallel to rebuild it.
Any suggestions where I might start looking to track down the problem?
After rebuilt, as indexing is IO intensive, we'll have lots of times where we are waiting on IO and not
using the CPU, so that we should change parallel_clause to Noparallel by alter index... noparallel, but it just can be perform in global index.
My question is that is there any way to change the partition index to noparallel after we use parallel to rebuild it.
Any suggestions where I might start looking to track down the problem?
1