MongoDB
索引相关操作
|
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(). |
后台建立索引 db.people.ensureIndex( { zipcode: 1}, {background: true} )
索引相关命令：http://docs.mongodb.org/manual/reference/indexes/
http://www.htsjk.com/shujukunews/968.html
www.htsjk.Com
true
http://www.htsjk.com/shujukunews/968.html
NewsArticle
MongoDB 索引相关操作 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() Remo...
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。