Hi, my script has about 10 SQL statements. All are very similar pulling different attributes from an oracle db.
Each SQL state has a where clause along the lines of:
WHERE fieldname IN (SELECT FIELD FROM TABLE WHERE STATUS = 1)
Now the embedded Select statement in each where clause is of course quite ineffective. Can I run that SQL statement first and then use the results in the subsequent SQL statements in order to speed up the overall load?