09-26-2008
17,
0
Join Date: Sep 2008
Last Activity: 17 July 2009, 9:47 PM EDT
Posts: 17
Thanks Given: 0
Thanked 0 Times in 0 Posts
which is better?
Hi,
I would like to know which works better in this scenario:
I have a file which contains about 300K to 400K records. This file will be loaded into an oracle table but will be filtered first. I have two ways of doing this.
1st, I filtered the original file and created a new file that contains only the selected records (using awk)
2nd, I included a WHERE clause in the sqlloader control file to filter the records
with these two options, which do you think is more efficient. (some explanations will be much appreciated) thank you.