Re: optimize query

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Thu, 30 Sep 1999 00:46:40 GMT
Message-ID: <QpyI3.1680$S2.17893866@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 Wed Sep 29 1999 - 19:46:40 CDT