索引相关操作
| Name | Description |
|---|---|
| db.collection.createIndex() | Builds an index on a collection. Use db.collection.ensureIndex(). |
| db.collection.dropIndex() | Removes a specified index on a collection. |
| db.collection.dropIndexes() | Removes all indexes on a collection. |
| db.collection.ensureIndex() | Creates an index if it does not currently exist. If the index existsensureIndex() does nothing. |
| db.collection.getIndexes() | Returns an array of documents that describe the existing indexes on a collection. |
| db.collection.getIndexStats() | Renders a human-readable view of the data collected by indexStats which reflects B-tree utilization. |
| db.collection.indexStats() | Renders a human-readable view of the data collected by indexStats which reflects B-tree utilization. |
| db.collection.reIndex() | Rebuilds all existing indexes on a collection. |
| db.collection.totalIndexSize() | Reports the total size used by the indexes on a collection. Provides a wrapper around the totalIndexSize field of the collStats output. |
| cursor.explain() | Reports on the query execution plan, including index use, for a cursor. |
| cursor.hint() | Forces MongoDB to use a specific index for a query. |
| cursor.max() | Specifies an exclusive upper index bound for a cursor. For use withcursor.hint() |
| cursor.min() | Specifies an inclusive lower index bound for a cursor. For use withcursor.hint() |
| cursor.snapshot() | Forces the cursor to use the index on the _id field. Ensures that the cursor returns each document, with regards to the value of the _id field, only once. |
| Name | Description |
|---|---|
| dropIndexes | Removes indexes from a collection. |
| compact | Defragments a collection and rebuilds the indexes. |
| reIndex | Rebuilds all indexes on a collection. |
| validate | Internal command that scans for a collection’s data and indexes for correctness. |
| indexStats | Experimental command that collects and aggregates statistics on all indexes. |
| geoNear | Performs a geospatial query that returns the documents closest to a given point. |
| geoSearch | Performs a geospatial query that uses MongoDB’s haystack index functionality. |
| geoWalk | An internal command to support geospatial queries. |
| checkShardingIndex | Internal command that validates index on shard key. |
Geospatial Query Selectors
| Name | Description |
|---|---|
| $geoWithin | Selects geometries within a bounding GeoJSON geometry. |
| $geoIntersects | Selects geometries that intersect with a GeoJSON geometry. |
| $near | Returns geospatial objects in proximity to a point. |
| $nearSphere | Returns geospatial objects in proximity to a point on a sphere. |
Indexing Query Modifiers
| Name | Description |
|---|---|
| $explain | Forces MongoDB to report on query execution plans. See explain(). |
| $hint | Forces MongoDB to use a specific index. See hint() |
| $max | Specifies an exclusive upper limit for the index to use in a query. Seemax(). |
| $min | Specifies an inclusive lower limit for the index to use in a query. See min(). |
| $returnKey | Forces the cursor to only return fields included in the index. |
| $snapshot | Forces the query to use the index on the _id field. See snapshot(). |

本文详细介绍了MongoDB中索引相关操作与优化方法,包括创建、删除、重建索引等,以及如何通过命令行查询索引状态和大小,旨在帮助开发者提升数据查询效率。

被折叠的 条评论
为什么被折叠?



