MongoDB Documentation, Release 3.0.4 Or, append hint() method to db.collection.explain().find() : Specify the $natural operator to the hint() method to prevent MongoDB from using any index: Instance Index Use Reporting MongoDB provides a number of metrics of index use and operation that you may want to consider when analyzing index use for your database: Instructions for creating and querying 2d , 2dsphere , and haystack indexes. Create a 2dsphere Index (page 530) A 2dsphere index supports data stored as both GeoJSON objects and as legacy coordinate pairs. Query a 2dsphere Index (page 531) Search for locations within, near, or intersected by a GeoJSON shape, or within a circle as defined by coordinate points on a sphere. Create a 2d Index (page 533) Create a 2d index to support queries on data stored as legacy coordinate pairs. Query a 2d Index (page 534) Search for locations using legacy coordinate pairs. Create a Haystack Index (page 536) A haystack index is optimized to return results over small areas. For queries that use spherical geometry, a 2dsphere index is a better option. Query a Haystack Index (page 536) Search based on location and non-location data within a small area. Calculate Distance Using Spherical Geometry (page 537) Convert distances to radians and back again. • In the output of serverStatus : – scanned – scanAndOrder • In the output of collStats : – totalIndexSize – indexSizes • In the output of dbStats : – dbStats.indexes – dbStats.indexSize db.people.find( { name: "John Doe", zipcode: { $gt: "63000" } } ).hint( { $natural: 1 } ) db.people.explain("executionStats").find( { name: "John Doe", zipcode: { $gt: "63000" } } ).hint( { zipcode: 1 } ) db.people.find( { name: "John Doe", zipcode: { $gt: "63000" } } ).hint( { zipcode: 1 } ).explain("executionStats") 8.3.3 Geospatial Index Tutorials 529 8.3. Indexing Tutorials