id	summary	reporter	owner	description	type	status	priority	milestone	component	resolution	keywords	cc	parents
142	Make sure we're using 100% efficient queries / indexes	Christopher Allan Webber	Christopher Allan Webber	"{{{
#!rst
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://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/Indexing+Advice+and+FAQ>`_
-  `http://www.mongodb.org/display/DOCS/Indexes <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 <http://www.mongodb.org/display/DOCS/Indexing+Advice+and+FAQ#IndexingAdviceandFAQ-Use%7B%7Bexplain>`_}}.

Assigning to myself, but feel free to claim this if you're excited
about investigating.



}}}"	enhancement	closed	trivial		programming	fixed	post-sql