3 ms·
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.
by jiryu 14y 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.
- MartinMond 14y agoYes 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 14y agoNope, 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.