Making Queries Faster

  • Thread starter Thread starter Anna S
  • Start date Start date
A

Anna S

Hi
I'm creating reports which show all of the information I
have in my database for a person. Since I want to access
just about every table in my database as well as format the
data and concatenate information from different fields etc,
I'm wondering how to make this as fast as possible.

Where can I find out what order Access 2000 performs its
operations in a query so that I can avoid making Access do
more work than necessary. For instance, do queries process
calculated fields first and then apply restricting
criteria? Which Query operations have the biggest time
overhead.

Intuitively I think that If I create and save a query
returning only the ID of the person I'm interested in, and
then use this query with tables and other queries, this
will improve the situation, but I would like to understand
all of the factors impacting on the efficiency of queries.

Thanks in advance
Anna
 
That is helpful. Thank you.
Anna
-----Original Message-----
Hi Anna

Access is very good at optimizing your queries, but it does not really
expose its execution plan.

There is an undocumented way of getting at some of this information by
hacking the registry to get it to ShowPlan. Details:
http://builder.com.com/5100-6388-5064388.html

http://msdn.microsoft.com/archive/d...MicrosoftAccessMicrosoftJetDatabaseEngine.asp


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top