Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 SubQuery Performance

Author  Topic 

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2001-07-11 : 16:54:09
How many level's of subquery's are acceptable before performance becomes an issue?
We have an access db with 3 to 4 levels of subqueries and I'm thinking this is why the queries are so slow. If I just rewrite them as one query would that make a big difference



Edited by - ValterBorges on 07/11/2001 16:58:06
   

- Advertisement -