At 11:08 AM 19/11/2004 -0500, Ann wrote:

>If you already have a index on each term, the compound index
>just gets in the way. If, however, you always ask for items
>by warehouse and shelf, and never by shelf alone, a compound
>index on warehouse and shelf is better than two separate indexes
>on warehouse and shelf because it has fewer duplicate values.
>If the fields are listed as warehouse, shelf, you can use that
>index to lookup everything in a warehouse

Yes

>or everything on a particular shelf in a warehouse.

Only if you include warehouse in the search, since the shelf segment won't
be visible for a shelf-only search, right?

Helen