Re: Fasten huge index rebuild - How To ?

Thanx zhu . i will pass on ur valuable suggestions to my friend.

Regards,
Prem.

• Zhu Wrote :=20 Don't have experience with domain index, but here are the tips for the btree index creation: 1. create the index local, unusable, 2. use several sessions to rebuild the individual partitions in parallel. 3. As rebuild index also need sort, give it a huge sort area size and retained size. 4. as rebuild will do full table/partition scan, give a big db_file_multiblock_read_count; 5. use nologging to speedup the action. 6. If you can bounce the instance, give a huge log_buffer helps when you are building index in logging mode. Hope it helps. By the way, seems db_file_directio_count does not help for the disk sort.
  --
  http://www.freelists.org/webpage/oracle-l