D
Dmitri Levin
Guest
For those who is using any kind of replication (OE replication or AI replication), meaning running After-images, proutil idxbuild will not work as mentioned above. For big tables one needs to add indexes inactive and then run proutil idxactivate. That is a great addition to the available tools. Note, You have to be on 11.7.2 and higher or version 12. And use -usernotifytime as a database startup parameter to be able to activate an index online without kicking everyone off. That would be all nice and fine if idxactivate would run multi-threaded like idxbuild. But unfortunately that is not the case !!! There is the big, huge speed difference between the two. And when idxbuild generally runs fast enough for all cases that I have seen, idxactivate could run for days, months and even years.
Continue reading...
Continue reading...