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: optimize query

Re: optimize query

From: Randy DeWoolfson <randy_at_euclidsys.com>
Date: Mon, 27 Sep 1999 14:14:00 -0400
Message-ID: <37EFB3E8.1EC5FDD3@euclidsys.com> 





take a look at the UNION clause.



randy



Vadim Grepan wrote:


> 


> Hello All!


> 


>   Is there any way to reduce SQL-query like


> 


>                 ...


>                 WHERE    x1 IN (a1, a2, ... an)  AND


>                                 x2 IN (a1, a2, ... an)  AND


>                                 x3 IN (a1, a2, ... an)


> 


>   In other words, can i use some cosntruction with meaning  (x1 ... xm) IN


> (a1 ... an)


>   (  where m < n of course :-)


> 


> Rgds, Vadim Grepan


> --------


> kezal_at_mail.ru


> 2:5020/653_at_fidonet.org


Received on Mon Sep 27 1999 - 13:14:00 CDT












Original text of this message













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