Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: GROUP BY

Re: GROUP BY

From: Marshall <marshall.spight_at_gmail.com>
Date: 18 May 2007 19:19:20 -0700
Message-ID: <1179541160.527580.51400@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 Fri May 18 2007 - 21:19:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US