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: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Thu, 30 Sep 1999 05:28:29 GMT
Message-ID: <1yCI3.1956$S2.18021101@France.EU.net>


Try to select your (a1, a2, ... an) in a real time view such as

SELECT
FROM
( select ai
 from
) an1,
( select ai
 from
) an2,
...
WHERE x1 = an2.ai

   AND x2 = an2.ai

and try to use UNION !

Randy DeWoolfson <randy_at_euclidsys.com> a écrit dans le message :
37EFB3E8.1EC5FDD3_at_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 Thu Sep 30 1999 - 00:28:29 CDT

Original text of this message

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