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

Home -> Community -> Usenet -> c.d.o.server -> Re: Query rewrite

Re: Query rewrite

From: Ryan S <rshevchi_at_vt.edu>
Date: 15 Jul 2005 13:24:08 -0700
Message-ID: <1121459048.714107.249790@g49g2000cwa.googlegroups.com> 





Since there is a SORT UNIQUE done for every select statement being
intersected why did you think that removing the distinct would be a
difference.  Create two tables and do a select with an intersect.  The
plan and time will be the same with or without the distinct.
Received on Fri Jul 15 2005 - 15:24:08 CDT












Original text of this message













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