Slow query

  • Thread starter wes via AccessMonster.com
  • Start date
W

wes via AccessMonster.com

Hi all,

I have a simple query -

SELECT SystemFiles.*
FROM SystemFiles;

that takes 15 min + to run.

there is a catch. I use Access as the front end and Oracle as the back end.

If any other info is needed please ask.

Any thoughts?

Wes
 
M

MGFoster

wes said:
Hi all,

I have a simple query -

SELECT SystemFiles.*
FROM SystemFiles;

that takes 15 min + to run.

there is a catch. I use Access as the front end and Oracle as the back end.

If any other info is needed please ask.

Any thoughts?
Click to expand...

How big is the table SystemFiles?

Try limiting the result set w/ a WHERE clause.

Try an SQL pass thru query.
 
Top