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.

Attachment: pgpTFwnzg0rF2.pgp
Description: PGP signature

Reply via email to