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

Home -> Community -> Usenet -> c.d.o.server -> Re: Index question

Re: Index question

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Wed, 2 Jul 2003 10:42:09 +0100
Message-ID: <SNxMa.21007$pK2.31732@news.indigo.ie>


Oracle Text ?
"Harry" <a_at_abc.com> wrote in message
news:KEkMa.288$rG2.904303_at_news-text.cableinet.net...
> I have a table containing 8 columns - the user can search on any of the
> fields and in any combination - how do you setup indexes to cope with
this?
>
> If you create one per column how does this work when say 5 columns are in
> the where clause?
>
> Surely I haven't got to create one for every combination?
>
> Any ideas?
>
> thanks
>
> harry
>
>
Received on Wed Jul 02 2003 - 04:42:09 CDT

Original text of this message

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