Toad World® Forums

Slow Running Query


#1

Hi

I have a pretty straightforward query that pulls 3 fields from a combination of 3 tables. When running the query in TDA it takes 15 minutes. When running in Access as a SQL Pass - Through, it takes 2-3 seconds.

Is there some sort of setting in TDA I may need to change in order to improve performance?

Thank you!


#2

How many fields/columns are in your query?

I’m wondering if the query is running fast and it’s just taking Toad a bit of time to format the data to display in the grid.

Queries in Toad should generally always run as fast as if not faster then ODBC Access executed queries, assuming you are using native drivers for connectivity.