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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why DISTINCT is costly?

Re: Why DISTINCT is costly?

From: Robert Klemme <bob.news_at_gmx.net>
Date: Mon, 12 Sep 2005 11:42:18 +0200
Message-ID: <3ol0s0F6e343U1@individual.net> 





sim wrote:


> In most cases it's better to use a group by than distinct. That should

> decrease the cost of your queries.




Why?  The task of identifying duplicates remains the same...



    robert
Received on Mon Sep 12 2005 - 04:42:18 CDT












Original text of this message













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