Advertisement
Guest User

Untitled

a guest
Jul 12th, 2013
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.46 KB | None | 0 0
  1. > 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()
  2. {
  3. "cursor" : "BtreeCursor LASTNAME_1_FIRSTNAME_1_EMAIL_1_CITY_1_STATUS_1",
  4. "isMultiKey" : false,
  5. "n" : 1771,
  6. "nscannedObjects" : 1771,
  7. "nscanned" : 382423,
  8. "nscannedObjectsAllPlans" : 1771,
  9. "nscannedAllPlans" : 382423,
  10. "scanAndOrder" : false,
  11. "indexOnly" : false,
  12. "nYields" : 2,
  13. "nChunkSkips" : 0,
  14. "millis" : 1487,
  15. "indexBounds" : {
  16. "LASTNAME" : [
  17. [
  18. {
  19. "$minElement" : 1
  20. },
  21. {
  22. "$maxElement" : 1
  23. }
  24. ]
  25. ],
  26. "FIRSTNAME" : [
  27. [
  28. {
  29. "$minElement" : 1
  30. },
  31. {
  32. "$maxElement" : 1
  33. }
  34. ]
  35. ],
  36. "EMAIL" : [
  37. [
  38. {
  39. "$minElement" : 1
  40. },
  41. {
  42. "$maxElement" : 1
  43. }
  44. ]
  45. ],
  46. "CITY" : [
  47. [
  48. {
  49. "$minElement" : 1
  50. },
  51. {
  52. "$maxElement" : 1
  53. }
  54. ]
  55. ],
  56. "STATUS" : [
  57. [
  58. {
  59. "$minElement" : 1
  60. },
  61. {
  62. "$maxElement" : 1
  63. }
  64. ]
  65. ]
  66. },
  67. "server" : "JARVISMOBIL:27017"
  68. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement