INDEX before OR after data LOAD
Posted by: Ahmad Sakhi
Date: May 13, 2016 07:00AM

Hello everyone,

I have a very large amount of data (~9 Billion records) that I need to load into a table. This data is currently stored on CSV files. The table is empty. It has INDEXes on some fields.

My question is,
Is it a good idea to first CREATE INDEXes while the table is empty?
OR
I load the data first, then do CREATE INDEXes?

Which method is advisable, specially that I am dealing with a large amount of data.

Thanks you.

Options: ReplyQuote


Subject
Written By
Posted
INDEX before OR after data LOAD
May 13, 2016 07:00AM


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.