Is there any way of speeding up data loads to tables with multiple indexes short of dropping & recreating the indexes before and after each load?
Printable View
Is there any way of speeding up data loads to tables with multiple indexes short of dropping & recreating the indexes before and after each load?
Use direct loading using DIRECT=Y of sqlloader to load after HWM.
Rgds
Ganesh .R