I have an Access db form with a button that runs through 12 various queries to get to my 13th and final one that exports out to Excel. Combination of SELECT, MAKE TABLE, DELETE AND APPEND queries on linked Oracle tables.
Tens of thousands of records (some in the 100k+) but only pulling a subset based on a drop down box on my form. Query takes about 3-5 minutes to complete.
I've been reading about pass through queries and PL/SQL for Oracle and am wondering what the opinions are out there about doing this to speed up my queries. I will need to learn PL/SQL but, if it won't make a significant speed improvement, I won't bother with it at this time.
Would appreciate anyone's thoughts on this.
Thanks,
Toni