Sub select speed improvement

#11

"David-W-Fenton" <NoEmail (AT) SeeSignature (DOT) invalid> wrote

Quote:

"ron paii" <none (AT) nospam (DOT) com> wrote in
news:j5g174$100$1 (AT) dont-email (DOT) me:

The DISTINCTROW is an artifact of the original query that returned
more then 1 row.

But you should never use DISTINCTROW except if you are trying to
make an otherwise non-updatable query updatable -- instead, you
should use DISTINCT. DISTINCTROW is a Jet/ACE-specific keyword and
not compatible. It occasionally can work some magic, making an
non-editable query with a join in the FROM clause editable, but a
query whose SELECT includes nothing but an aggregate function is not
going to be editable in the first place.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

According to my documentation the original version of this query was created
in 1999, I don't remember why it has DISTICTROW other then not knowing what
I know now. Removing it improved performance and gave me the same result.
The program had it's start in Access 2, which I was reminded in a different
thread defaulted to DISTINCTROW.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sub select speed improvement

comp.databases.ms-access comp.databases.ms-access

Re: Sub select speed improvement - 09-25-2011 , 05:37 PM