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 -> DISTINCT as a way to slow down queries

DISTINCT as a way to slow down queries

From: cumin <jkilbourne_at_gmail.com>
Date: 3 Oct 2005 12:10:50 -0700
Message-ID: <1128366650.194740.173620@g49g2000cwa.googlegroups.com> 





I just ran a query, SELECT blah blah, and had to hit Ctrl-C as the
results flew by; 6000 rows of the same two values. So I added DISTINCT
to the front, and I am still waiting for results 10 minutes later. Why
does DISTINCT have such a dramatic effect on performance?
Received on Mon Oct 03 2005 - 14:10:50 CDT












Original text of this message













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