WingNews logo WingNews
top | item 4628182

(no title)

jiryu | 13 years ago

No - it can only use one for a given query. But a compound index like the ones I describe in the post can index many fields.

discuss

order

MartinMond|13 years ago

Yes of course, but it's kinda slow if you have to maintain one compound index for each possible query you're going to run, that's why I was asking.

chmod775|13 years ago

Nope, you can use the compound index 'a,b,c' to query over the following fields:

    a
    a.b
    a,b,c
The manual actually explains it like that.