# Optimizing MongoDB Compound Indexes

<http://emptysqua.re/blog/optimizing-mongodb-compound-indexes/>

- Host: [emptysqua.re](https://links.thingelstad.xyz/hosts/emptysqua.re/)
- Saved: October 8, 2012 (2012-10-08T20:08:13Z)
- Record: https://links.thingelstad.xyz/links/ab20af3bfec5/
- JSON: https://links.thingelstad.xyz/links/ab20af3bfec5.json

## From the page (probably an excerpt, not Jamie's words)

How do you create the best index for a complex MongoDB query? I'll present a method specifically for queries that combine equality tests, sorts, and range filters, and demonstrate the best order for fields in a compound index. We'll look at the explain() output to see exactly how well it performs, and we'll see how the MongoDB query-optimizer selects an index.

## Facts

- Kind: [Page](https://links.thingelstad.xyz/kinds/page/)

## Saved the same week

- [The Blue Collar Coder](https://links.thingelstad.xyz/links/2692f0e17969/) (dashes.com, October 8, 2012)
- [Facebook tests Collections posts with Want and Collect buttons for retailers](https://links.thingelstad.xyz/links/246836250e1d/) (insidefacebook.com, October 8, 2012)
- [Cycling Investigation - USADA](https://links.thingelstad.xyz/links/a24a5959f948/) (cyclinginvestigation.usada.org, October 10, 2012)
- [Facebook Marketing Platform 8thBridge Graphite Gets New Features](https://links.thingelstad.xyz/links/dd3d2df8142d/) (allfacebook.com, October 11, 2012)
- [The Magazine Marco.org](https://links.thingelstad.xyz/links/156cce5f628a/) (marco.org, October 11, 2012)

## Elsewhere

- Wayback Machine: https://web.archive.org/web/*/http://emptysqua.re/blog/optimizing-mongodb-compound-indexes/