Super slow load data infile with index
I am loading tab delimited data from numerous files into a newly created table. If I use three non-unique value indexes then load times increase almost exponentially. Without index, loads times are almost linear with number of records.
File Records Time w/index Time w/o index
1 981,775 94.6 60.6s
2 938,626 116.6 55.6
3 993,750 158.1 56.5
What can I do to speed up the loading with indexing?
Subject
Views
Written By
Posted
Super slow load data infile with index
1502
June 17, 2014 12:04PM
874
June 23, 2014 07:26PM
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.