Compare performance between Sub Query and SQL subquery

  • Thread starter Thread starter Malee
  • Start date Start date
M

Malee

I always create Access Query oject which join between Table and another Sub
Query object. I think by using this way, It is easier to build a complex
query than using SQL subquery.

But now, I have to care about performance. So, I would like to ask you ,
Which method is better in performance.

TIA,
Malee
 
Hi,

In theory sub-query can be optimize knowing the whole problem, but in
practice, it is often observable that a solution based on embedded queries
run faster. Go for maintenance first, then optimize for speed, by testing
alternatives, if it is required. Note that correlated sub-query cannot be
simulated through embedded queries.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top