Re: GROUP BY

From: Marshall <marshall.spight_at_gmail.com>
Date: 18 May 2007 19:19:20 -0700
Message-ID: <1179541160.527580.51400_at_q23g2000hsg.googlegroups.com>

On May 18, 12:31 pm, "David Cressey" <cresse..._at_verizon.net> wrote:
>
> A lot of newbie SQL writers learn to avoid "select distinct"
> because "it runs too slow".

Once I had a query that I happened to notice ran *faster* when I added distinct, even though the results were the same either way. I wish I'd written it down.

Marshall Received on Sat May 19 2007 - 04:19:20 CEST

This message: [ Message body ]
Next message: Kevin Porter: "Question about "linking tables""
Previous message: Marshall: "Re: GROUP BY"
In reply to: David Cressey: "Re: GROUP BY"
In reply to David Cressey: "Re: GROUP BY"
Next in thread: David Portas: "Re: GROUP BY"
Reply: David Cressey: "Re: GROUP BY"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message