SEO

#1 (**permalink**) 02-22-2008, 05:38 PM

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

#2 (**permalink**) 02-22-2008, 05:38 PM

Harry wrote:

> 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

You don't.

One does not build indexes without a lot more information than you have
provided.

1. How many rows?
2. What kind of data?
3. Cardinality?
4. What percentage of the rows will be returned with a query?
5. Partitions?
6. Nulls?
7. Functions?
8. Primary key and/or unique constraints?
9. What is the response time without indexes?
10. Explain plans demonstrating that indexes will actually be used by the
optimizer

Oh at version version version. We can't look over your shoulder.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

#3 (**permalink**) 02-22-2008, 05:39 PM

Oracle Text ?
"Harry" <a@abc.com> wrote in message
news:KEkMa.288$rG2.904303@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
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Index question