Slow query

  • Thread starter Thread starter wes via AccessMonster.com
  • Start date 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
 
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.
 
Back
Top