Query Optimization

  • Thread starter Thread starter masayoshi hayashi
  • Start date Start date
M

masayoshi hayashi

I have read the article in MSDN:
http://msdn.microsoft.com/library/d...tml/dgusing_rushmore_to_speed_data_access.asp

Does Access query optimizer optimize whole hierachical set of queries
if I save the last query, or does the optimizer optimize only the last
query?

For example, I have a set of queries that takes about one and half
hour on pen4 machine.

Please suppose a set of saved queries, q1, q2, q3, q4

By my query design, the flow of info is such that
q1->q2
q2->q4
q3->q4

The last query here is q4.
The hierachical set is {q1,q2,q3,q4}.

Let's say I change some table designs involved in the queries q1~q4
such as indexing and table relationships. Is it sufficient to open the
sql view and save q4 to optimize the flow of the hierachical set of
queries, or should I open and save each one of them?
 
the optimizer executes each time a query is executed

q1->optimizer->executed
q2->optimizer->executed ...

you might try the performance analyzer in Access for
additional hints on indexes...
 
My feeling is that you are looking in the wrong place for a solution. If your
four queries are taking an hour and a half, my recommendation is that you should
be looking at the network connections if your database is on a network and the
design of your tables.
 
Back
Top