Index question

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 Tue Jul 01 2003 - 13:44:58 CDT