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: Ora 9.2 SQL: What's the fastest way to do this set operation...

Re: Ora 9.2 SQL: What's the fastest way to do this set operation...

From: dean <deanbrown3d_at_yahoo.com>
Date: 3 May 2006 07:00:30 -0700
Message-ID: <1146664830.616295.228380@j73g2000cwa.googlegroups.com> 





I usually try with and without the distinct keywork in cases such as
this, and choose the fastest one.



So basically, there is no hack that can determine if two sets overlap,
without actually determining the intersect, in SQL. That's fine if that
is the answer.



Thanks all,



Dean
Received on Wed May 03 2006 - 09:00:30 CDT












Original text of this message













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