Tables aren't indexed

  • Thread starter Thread starter David
  • Start date Start date
D

David

I am using Access through and ODBC connection to a Cache database on one of
our servers at work. I can't change anything about the global tables
provided by the company and i need to query off of them. The problem is
that these tables are very large and are not indexed in any way. is there
another way to write a query around that problem so it doesn't take all
night to run?
 
I am using Access through and ODBC connection to a Cache database on one
of our servers at work. I can't change anything about the global tables
provided by the company and i need to query off of them. The problem is
that these tables are very large and are not indexed in any way. is
there another way to write a query around that problem so it doesn't
take all night to run?
Click to expand...

If you are really writing the best structured query for the task at hand
and that takes a long time because there are no indexes then no, there is
not much you can do.

Are you writing a pass-through query to the database server or are you
querying against a link? The former could be a lot faster (depending
again on the query).
 
Back
Top