On Thu, Dec 01, 2005 at 05:33:01PM +0100, Andy Pieters wrote: > Hi list > > I have a data set that is composed of many fields (30+). The final app will > allow the users to search records on each field. > > What is the best thing to index in this situation? Make an index for *all* > fields? You woudn't want one index that contains all fields, as there is no efficient way to search it for a field that isn't on the 'leading edge' of the index. You'd be better off with a seperate index for each field.
-Jason Martin -- If you don't like the news, go out and make some of your own. This message is PGP/MIME signed.
pgpTFwnzg0rF2.pgp
Description: PGP signature