Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index question
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
![]() |
![]() |