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