Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > db.users.find({"$or":[{"LASTNAME":{"$regex":"^Schm"}},{"LASTNAME":{"$regex":"^schm"}},{"LASTNAME":{"$regex":"^SCHM"}}]}).sort({ "LASTNAME":1,"FIRSTNAME":1,"EMAIL":1,"CITY":1,"STATUS":1}).explain()
- {
- "cursor" : "BtreeCursor LASTNAME_1_FIRSTNAME_1_EMAIL_1_CITY_1_STATUS_1",
- "isMultiKey" : false,
- "n" : 1771,
- "nscannedObjects" : 1771,
- "nscanned" : 382423,
- "nscannedObjectsAllPlans" : 1771,
- "nscannedAllPlans" : 382423,
- "scanAndOrder" : false,
- "indexOnly" : false,
- "nYields" : 2,
- "nChunkSkips" : 0,
- "millis" : 1487,
- "indexBounds" : {
- "LASTNAME" : [
- [
- {
- "$minElement" : 1
- },
- {
- "$maxElement" : 1
- }
- ]
- ],
- "FIRSTNAME" : [
- [
- {
- "$minElement" : 1
- },
- {
- "$maxElement" : 1
- }
- ]
- ],
- "EMAIL" : [
- [
- {
- "$minElement" : 1
- },
- {
- "$maxElement" : 1
- }
- ]
- ],
- "CITY" : [
- [
- {
- "$minElement" : 1
- },
- {
- "$maxElement" : 1
- }
- ]
- ],
- "STATUS" : [
- [
- {
- "$minElement" : 1
- },
- {
- "$maxElement" : 1
- }
- ]
- ]
- },
- "server" : "JARVISMOBIL:27017"
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement