INDEX before OR after data LOAD
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.
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.