Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Efficient use of WITHIN (intermedia)
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 KReceived on Mon Feb 26 2001 - 07:40:22 CST
![]() |
![]() |