【问题】$or中的数据作为索引的一些问题

由于满足 "101 <= C2 <= 200"这个关系的document只有5998条，因此很希望能够C2作为索引:

db.test.find({C1:{$lte:20120306235959},$or:[{C2:{$gte:101,$lte:200}}]}).hint({C2:1}).sort({C16:-1}).limit(23).explain()
        "cursor" : "BtreeCursor C2_1",
        "nscanned" : 2317450,
        "nscannedObjects" : 5998,
        "n" : 23,
        "scanAndOrder" : true,
        "millis" : 5094,
        "nYields" : 6,
        "nChunkSkips" : 0,
        "isMultiKey" : false,
        "indexOnly" : false,
        "indexBounds" : {
                "C2" : [
                        [
                                {
                                        "$minElement" : 1
                                },
                                {
                                        "$maxElement" : 1
                                }
                        ]
                ]
        }
       
2317450是document总的大小，还是把所有的数据都扫描了一遍

如果去掉$or

db.test.find({C1:{$lte:20120306235959}, C2:{$gte:101,$lte:200}}).hint({C2:1}).sort({C16:-1}).limit(23).explain()
        "cursor" : "BtreeCursor C2_1",
        "nscanned" : 5998,
        "nscannedObjects" : 5998,
        "n" : 23,
        "scanAndOrder" : true,
        "millis" : 63,
        "nYields" : 0,
        "nChunkSkips" : 0,
        "isMultiKey" : false,
        "indexOnly" : false,
        "indexBounds" : {
                "C2" : [
                        [
                                101,
                                200
                        ]
                ]
        }
这个才是希望的结果

但由于业务的需求，$or是需要的，不能去掉。

这个问题正在询问中。。。