Re: INDEX before OR after data LOAD
Posted by: Peter Brawley
Date: May 13, 2016 09:28AM

Load Data is faster without indexes or in PK order with no other indexes to update. The more rows in a table, the longer index creation will take. So I would turn off indexes before the Loads, do the Loads, then index.

Options: ReplyQuote


Subject
Written By
Posted
Re: INDEX before OR after data LOAD
May 13, 2016 09:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.