Opened 15 years ago
Last modified 14 years ago
#142 closed enhancement
Make sure we're using 100% efficient queries / indexes — at Initial Version
| Reported by: | Christopher Allan Webber | Owned by: | Christopher Allan Webber |
|---|---|---|---|
| Priority: | trivial | Milestone: | |
| Component: | programming | Keywords: | post-sql |
| Cc: | Parent Tickets: |
Description
Every query we use should be able to efficiently use an index, yet at the same time, we shouldn't create superflous indexes.
Related:
- http://kylebanker.com/blog/2010/09/21/the-joy-of-mongodb-indexes/
- http://www.mongodb.org/display/DOCS/Indexing+Advice+and+FAQ
- http://www.mongodb.org/display/DOCS/Indexes
Especially, we should play with using explain:
http://www.mongodb.org/display/DOCS/Indexing+Advice+and+FAQ#IndexingAdviceandFAQ-Use{{explain}}.
Assigning to myself, but feel free to claim this if you're excited about investigating.
