I am using Toad for Data Analysts 3.1, and I have a query that is a very simple SELECT with an INNER JOIN on 2 different data sources.
An hour later, after getting a “Microsoft Access” error, I discovered that in the properties of my Oracle connection, the ODBC Driver needed changed from to my 11g driver.
Now, as my query continues to churn and churn… I’m wondering if I also need to do something with the SQL Server connection. The properties currently say .
Are these settings optimal for performance? I’m joining 900k rows on SQL Server to 60.0 MM rows on the Oracle connection. Joined on a single Primary Key.