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.

You could test both and verify.
Me personally, I would use one tool (sqlldr) if possible.