Re: Load Data Infile takes a long time
Thank you so much guys! The performance is much better now!! To summarize, I think what has really clicked:
1. Having an id column as primary key and the other huge column combinations as secondary key
2. Reducing the number of partitions.
3. Getting rid of unnecessary secondary indexes.
Thanks again!
Subject
Views
Written By
Posted
6499
March 15, 2013 04:44PM
2394
March 16, 2013 06:15PM
2193
March 17, 2013 11:39PM
2060
March 17, 2013 11:05PM
2076
March 18, 2013 03:04AM
1803
March 19, 2013 08:28PM
1695
March 20, 2013 12:25PM
1679
March 20, 2013 05:03PM
Re: Load Data Infile takes a long time
1634
March 26, 2013 11:06AM
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.