Slow query

[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

 

[MGFoster]

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?

How big is the table SystemFiles?

Try limiting the result set w/ a WHERE clause.

Try an SQL pass thru query.