Stijn Vanroye wrote:
> Thanks for the reply. I was afraid it would come down to testing each
> individual situation.µ The table I mentioned (6 million+ records)
> actually is a phonebook. And searching and filtering is possible on
> almost any combination of fields. So there's an index on each
> individual field now and that's it. Works relatively fast now anyway.
Keep an eye on the stats tables, and introduce compound indexes one at a
time would be my recommendation
--
Richard Huxton
Archonet Ltd