Query Execution Time

ReAn

Dangerous Programmer...
Local time
Today, 14:45
Joined
Jun 25, 2004
Messages
250
I have a query, it joins a local table to a remote table (Oracle Database Table) which makes it slow(ish).

When I am in design mode and i click the "View Datalist" button, which visually shows me the results, the query executes in about 12 seconds.

When I use the "!" Button to physically Execute the Make-Table Query, it takes hours.

What things should i look for that might cause this problem? Where do I need to optimize.

To me it seems rather odd that the query would execute so fast when i view the data than when it physically executes the data.

Same speed problems when i just run the query as a Selection Query as opposed to the Make-Table Query, so it's not an issue of writing to disk/etc.
 
Correction: Making my query a 'Select Query' allows it to run at a realistic speed. This however does not solve my problem, anyone know why this might be happening?
 
What about an append query, how long does that take?
 

Users who are viewing this thread

Back
Top Bottom