M
Mikael Lindqvist
Hi,
Although I have a few books on MS Access I have not come over any topic that
discuss the aspects of speed when creating queries.
For example, in my case I'm doing a "simple" query that draws the material
from several tables (some very large), most tables are linked (ODBC) and the
querying can be really slow,.. which made me start thinking about ways to
construct more efficient queries.
So, if someone could give some general advise, or point to an applied
textbook on how to speed up the queries I'd be really thankful.
(One thing that should boost the query would be if I could, somehow, make
one query filter the biggest table, and then run the other queries AFTER
that... sort of "sequential queries"... but I don't know how).
Cheers,
Mikael
Sweden
Although I have a few books on MS Access I have not come over any topic that
discuss the aspects of speed when creating queries.
For example, in my case I'm doing a "simple" query that draws the material
from several tables (some very large), most tables are linked (ODBC) and the
querying can be really slow,.. which made me start thinking about ways to
construct more efficient queries.
So, if someone could give some general advise, or point to an applied
textbook on how to speed up the queries I'd be really thankful.
(One thing that should boost the query would be if I could, somehow, make
one query filter the biggest table, and then run the other queries AFTER
that... sort of "sequential queries"... but I don't know how).
Cheers,
Mikael
Sweden