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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Efficient use of WITHIN (intermedia)

Re: Efficient use of WITHIN (intermedia)

From: Morten Primdahl <morten_at_caput.com>
Date: Mon, 26 Feb 2001 14:40:22 +0100
Message-ID: <3A9A5CC6.A011EDCA@caput.com>

timkarnold wrote:
>
> Why not just (some_query)?
> I believe 'WITHIN' is restrictive. If you don't want to restrict to a
> section, why use it?

If I have eg. 20 sections, but only wish to look in 5 of those, then I'll need a construct of 5 WITHIN and 4 OR's - which I had hoped to be able to avoid (or optimize rather).

>
> "Morten Primdahl" <morten_at_caput.com> wrote in message
> news:3A9A1F08.ED90C8B6_at_caput.com...
> >
> > Hi. Is there a better way to use WITHIN in a context query, than
> >
> > (some_query WITHIN section1) OR
> > (some_query WITHIN section2) OR
> > ..
> > (some_query WITHIN sectionN)
> >
> > I've tried things like WITHIN (section1, section2, .. ,sectionN)
> > but to no avail.
> >
> > Thanks
> >
> > Morten
> >
> > --
> > Morten Primdahl Caput A/S Tel +45 70 12 24 42
> > morten_at_caput.com Nygade 6 Fax +45 70 11 24 42
> > http://www.caput.com/ DK-1164 Kbh K
 

-- 
Morten Primdahl         Caput A/S       Tel +45 70 12 24 42
morten_at_caput.com        Nygade 6        Fax +45 70 11 24 42
http://www.caput.com/   DK-1164 Kbh K
Received on Mon Feb 26 2001 - 07:40:22 CST

Original text of this message

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