mongo索引创建和索引分析

最新推荐文章于 2024-10-01 14:54:29 发布
最新推荐文章于 2024-10-01 14:54:29 发布
阅读量641 收藏
点赞数
分类专栏： NoSql 文章标签： mongodb 索引
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/guugle2010/article/details/73400950
版权 
for(i=0; i<20000; i++){
... db.numbers.save({num: i});
... }
WriteResult({ "nInserted" : 1 })
> db.numbers.count()
20000
> db.numbers.find()
{ "_id" : ObjectId("59455ad5961eb6f4b52b6762"), "num" : 0 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6763"), "num" : 1 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6764"), "num" : 2 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6765"), "num" : 3 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6766"), "num" : 4 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6767"), "num" : 5 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6768"), "num" : 6 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6769"), "num" : 7 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b676a"), "num" : 8 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b676b"), "num" : 9 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b676c"), "num" : 10 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b676d"), "num" : 11 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b676e"), "num" : 12 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b676f"), "num" : 13 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6770"), "num" : 14 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6771"), "num" : 15 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6772"), "num" : 16 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6773"), "num" : 17 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6774"), "num" : 18 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6775"), "num" : 19 }
Type "it" for more
> it
{ "_id" : ObjectId("59455ad5961eb6f4b52b6776"), "num" : 20 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6777"), "num" : 21 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6778"), "num" : 22 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6779"), "num" : 23 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677a"), "num" : 24 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677b"), "num" : 25 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677c"), "num" : 26 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677d"), "num" : 27 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677e"), "num" : 28 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677f"), "num" : 29 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6780"), "num" : 30 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6781"), "num" : 31 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6782"), "num" : 32 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6783"), "num" : 33 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6784"), "num" : 34 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6785"), "num" : 35 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6786"), "num" : 36 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6787"), "num" : 37 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6788"), "num" : 38 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6789"), "num" : 39 }
Type "it" for more
> db.numbers.find({num:500})
{ "_id" : ObjectId("59455ad5961eb6f4b52b6956"), "num" : 500 }
> db.numbers.find({num:{"$gt":19995}})
{ "_id" : ObjectId("59455adb961eb6f4b52bb57e"), "num" : 19996 }
{ "_id" : ObjectId("59455adb961eb6f4b52bb57f"), "num" : 19997 }
{ "_id" : ObjectId("59455adb961eb6f4b52bb580"), "num" : 19998 }
{ "_id" : ObjectId("59455adb961eb6f4b52bb581"), "num" : 19999 }
> db.numbers.find({num:{"$gt":20, "$lt":25}})
{ "_id" : ObjectId("59455ad5961eb6f4b52b6777"), "num" : 21 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6778"), "num" : 22 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6779"), "num" : 23 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677a"), "num" : 24 }
> db.numbers.find({num:{"$gte":20, "$lte":25}})
{ "_id" : ObjectId("59455ad5961eb6f4b52b6776"), "num" : 20 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6777"), "num" : 21 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6778"), "num" : 22 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b6779"), "num" : 23 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677a"), "num" : 24 }
{ "_id" : ObjectId("59455ad5961eb6f4b52b677b"), "num" : 25 }
> db.numbers.find({num:{"$gt":19995}}).explain("executionStats")
{
	"queryPlanner" : {
		"plannerVersion" : 1,
		"namespace" : "tutorial.numbers",
		"indexFilterSet" : false,
		"parsedQuery" : {
			"num" : {
				"$gt" : 19995
			}
		},
		"winningPlan" : {
			"stage" : "COLLSCAN",
			"filter" : {
				"num" : {
					"$gt" : 19995
				}
			},
			"direction" : "forward"
		},
		"rejectedPlans" : [ ]
	},
	"executionStats" : {
		"executionSuccess" : true,
		"nReturned" : 4,
		"executionTimeMillis" : 10,
		"totalKeysExamined" : 0,
		"totalDocsExamined" : 20000,
		"executionStages" : {
			"stage" : "COLLSCAN",
			"filter" : {
				"num" : {
					"$gt" : 19995
				}
			},
			"nReturned" : 4,
			"executionTimeMillisEstimate" : 11,
			"works" : 20002,
			"advanced" : 4,
			"needTime" : 19997,
			"needYield" : 0,
			"saveState" : 156,
			"restoreState" : 156,
			"isEOF" : 1,
			"invalidates" : 0,
			"direction" : "forward",
			"docsExamined" : 20000
		}
	},
	"serverInfo" : {
		"host" : "GuGangdeMacBook-Pro.local",
		"port" : 27017,
		"version" : "3.4.4",
		"gitVersion" : "888390515874a9debd1b6c5d36559ca86b44babd"
	},
	"ok" : 1
}
> db.numbers.getIndexes()
[
	{
		"v" : 2,
		"key" : {
			"_id" : 1
		},
		"name" : "_id_",
		"ns" : "tutorial.numbers"
	}
]
> db.numbers.creatIndex({num:1})
2017-06-18T00:46:35.030+0800 E QUERY    [thread1] TypeError: db.numbers.creatIndex is not a function :
@(shell):1:1
> db.numbers.createIndex({num:1})
{
	"createdCollectionAutomatically" : false,
	"numIndexesBefore" : 1,
	"numIndexesAfter" : 2,
	"ok" : 1
}
> db.numbers.getIndexes()
[
	{
		"v" : 2,
		"key" : {
			"_id" : 1
		},
		"name" : "_id_",
		"ns" : "tutorial.numbers"
	},
	{
		"v" : 2,
		"key" : {
			"num" : 1
		},
		"name" : "num_1",
		"ns" : "tutorial.numbers"
	}
]
> db.numbers.find({num:{"$gt":19995}}).explain("executionStats")
{
	"queryPlanner" : {
		"plannerVersion" : 1,
		"namespace" : "tutorial.numbers",
		"indexFilterSet" : false,
		"parsedQuery" : {
			"num" : {
				"$gt" : 19995
			}
		},
		"winningPlan" : {
			"stage" : "FETCH",
			"inputStage" : {
				"stage" : "IXSCAN",
				"keyPattern" : {
					"num" : 1
				},
				"indexName" : "num_1",
				"isMultiKey" : false,
				"multiKeyPaths" : {
					"num" : [ ]
				},
				"isUnique" : false,
				"isSparse" : false,
				"isPartial" : false,
				"indexVersion" : 2,
				"direction" : "forward",
				"indexBounds" : {
					"num" : [
						"(19995.0, inf.0]"
					]
				}
			}
		},
		"rejectedPlans" : [ ]
	},
	"executionStats" : {
		"executionSuccess" : true,
		"nReturned" : 4,
		"executionTimeMillis" : 4,
		"totalKeysExamined" : 4,
		"totalDocsExamined" : 4,
		"executionStages" : {
			"stage" : "FETCH",
			"nReturned" : 4,
			"executionTimeMillisEstimate" : 0,
			"works" : 5,
			"advanced" : 4,
			"needTime" : 0,
			"needYield" : 0,
			"saveState" : 0,
			"restoreState" : 0,
			"isEOF" : 1,
			"invalidates" : 0,
			"docsExamined" : 4,
			"alreadyHasObj" : 0,
			"inputStage" : {
				"stage" : "IXSCAN",
				"nReturned" : 4,
				"executionTimeMillisEstimate" : 0,
				"works" : 5,
				"advanced" : 4,
				"needTime" : 0,
				"needYield" : 0,
				"saveState" : 0,
				"restoreState" : 0,
				"isEOF" : 1,
				"invalidates" : 0,
				"keyPattern" : {
					"num" : 1
				},
				"indexName" : "num_1",
				"isMultiKey" : false,
				"multiKeyPaths" : {
					"num" : [ ]
				},
				"isUnique" : false,
				"isSparse" : false,
				"isPartial" : false,
				"indexVersion" : 2,
				"direction" : "forward",
				"indexBounds" : {
					"num" : [
						"(19995.0, inf.0]"
					]
				},
				"keysExamined" : 4,
				"seeks" : 1,
				"dupsTested" : 0,
				"dupsDropped" : 0,
				"seenInvalidated" : 0
			}
		}
	},
	"serverInfo" : {
		"host" : "GuGangdeMacBook-Pro.local",
		"port" : 27017,
		"version" : "3.4.4",
		"gitVersion" : "888390515874a9debd1b6c5d36559ca86b44babd"
	},
	"ok" : 1
}
> db.numbers.find({num:{"$gt":19995}}).explain("executionStats")
{
	"queryPlanner" : {
		"plannerVersion" : 1,
		"namespace" : "tutorial.numbers",
		"indexFilterSet" : false,
		"parsedQuery" : {
			"num" : {
				"$gt" : 19995
			}
		},
		"winningPlan" : {
			"stage" : "FETCH",
			"inputStage" : {
				"stage" : "IXSCAN",
				"keyPattern" : {
					"num" : 1
				},
				"indexName" : "num_1",
				"isMultiKey" : false,
				"multiKeyPaths" : {
					"num" : [ ]
				},
				"isUnique" : false,
				"isSparse" : false,
				"isPartial" : false,
				"indexVersion" : 2,
				"direction" : "forward",
				"indexBounds" : {
					"num" : [
						"(19995.0, inf.0]"
					]
				}
			}
		},
		"rejectedPlans" : [ ]
	},
	"executionStats" : {
		"executionSuccess" : true,
		"nReturned" : 4,
		"executionTimeMillis" : 0,
		"totalKeysExamined" : 4,
		"totalDocsExamined" : 4,
		"executionStages" : {
			"stage" : "FETCH",
			"nReturned" : 4,
			"executionTimeMillisEstimate" : 0,
			"works" : 5,
			"advanced" : 4,
			"needTime" : 0,
			"needYield" : 0,
			"saveState" : 0,
			"restoreState" : 0,
			"isEOF" : 1,
			"invalidates" : 0,
			"docsExamined" : 4,
			"alreadyHasObj" : 0,
			"inputStage" : {
				"stage" : "IXSCAN",
				"nReturned" : 4,
				"executionTimeMillisEstimate" : 0,
				"works" : 5,
				"advanced" : 4,
				"needTime" : 0,
				"needYield" : 0,
				"saveState" : 0,
				"restoreState" : 0,
				"isEOF" : 1,
				"invalidates" : 0,
				"keyPattern" : {
					"num" : 1
				},
				"indexName" : "num_1",
				"isMultiKey" : false,
				"multiKeyPaths" : {
					"num" : [ ]
				},
				"isUnique" : false,
				"isSparse" : false,
				"isPartial" : false,
				"indexVersion" : 2,
				"direction" : "forward",
				"indexBounds" : {
					"num" : [
						"(19995.0, inf.0]"
					]
				},
				"keysExamined" : 4,
				"seeks" : 1,
				"dupsTested" : 0,
				"dupsDropped" : 0,
				"seenInvalidated" : 0
			}
		}
	},
	"serverInfo" : {
		"host" : "GuGangdeMacBook-Pro.local",
		"port" : 27017,
		"version" : "3.4.4",
		"gitVersion" : "888390515874a9debd1b6c5d36559ca86b44babd"
	},
	"ok" : 1
}
> db.stats()
{
	"db" : "tutorial",
	"collections" : 1,
	"views" : 0,
	"objects" : 20000,
	"avgObjSize" : 35,
	"dataSize" : 700000,
	"storageSize" : 352256,
	"numExtents" : 0,
	"indexes" : 2,
	"indexSize" : 425984,
	"ok" : 1
}
> db.numbers.stats()
{
	"ns" : "tutorial.numbers",
	"size" : 700000,
	"count" : 20000,
	"avgObjSize" : 35,
	"storageSize" : 352256,
	"capped" : false,
	"wiredTiger" : {
		"metadata" : {
			"formatVersion" : 1
		},
		"creationString" : "access_pattern_hint=none,allocation_size=4KB,app_metadata=(formatVersion=1),block_allocation=best,block_compressor=snappy,cache_resident=false,checksum=on,colgroups=,collator=,columns=,dictionary=0,encryption=(keyid=,name=),exclusive=false,extractor=,format=btree,huffman_key=,huffman_value=,ignore_in_memory_cache_size=false,immutable=false,internal_item_max=0,internal_key_max=0,internal_key_truncate=true,internal_page_max=4KB,key_format=q,key_gap=10,leaf_item_max=0,leaf_key_max=0,leaf_page_max=32KB,leaf_value_max=64MB,log=(enabled=true),lsm=(auto_throttle=true,bloom=true,bloom_bit_count=16,bloom_config=,bloom_hash_count=8,bloom_oldest=false,chunk_count_limit=0,chunk_max=5GB,chunk_size=10MB,merge_max=15,merge_min=0),memory_page_max=10m,os_cache_dirty_max=0,os_cache_max=0,prefix_compression=false,prefix_compression_min=4,source=,split_deepen_min_child=0,split_deepen_per_child=0,split_pct=90,type=file,value_format=u",
		"type" : "file",
		"uri" : "statistics:table:collection-2--2591950180216266366",
		"LSM" : {
			"bloom filter false positives" : 0,
			"bloom filter hits" : 0,
			"bloom filter misses" : 0,
			"bloom filter pages evicted from cache" : 0,
			"bloom filter pages read into cache" : 0,
			"bloom filters in the LSM tree" : 0,
			"chunks in the LSM tree" : 0,
			"highest merge generation in the LSM tree" : 0,
			"queries that could have benefited from a Bloom filter that did not exist" : 0,
			"sleep for LSM checkpoint throttle" : 0,
			"sleep for LSM merge throttle" : 0,
			"total size of bloom filters" : 0
		},
		"block-manager" : {
			"allocations requiring file extension" : 30,
			"blocks allocated" : 30,
			"blocks freed" : 0,
			"checkpoint size" : 339968,
			"file allocation unit size" : 4096,
			"file bytes available for reuse" : 0,
			"file magic number" : 120897,
			"file major version number" : 1,
			"file size in bytes" : 352256,
			"minor version number" : 0
		},
		"btree" : {
			"btree checkpoint generation" : 30,
			"column-store fixed-size leaf pages" : 0,
			"column-store internal pages" : 0,
			"column-store variable-size RLE encoded values" : 0,
			"column-store variable-size deleted values" : 0,
			"column-store variable-size leaf pages" : 0,
			"fixed-record size" : 0,
			"maximum internal page key size" : 368,
			"maximum internal page size" : 4096,
			"maximum leaf page key size" : 2867,
			"maximum leaf page size" : 32768,
			"maximum leaf page value size" : 67108864,
			"maximum tree depth" : 3,
			"number of key/value pairs" : 0,
			"overflow pages" : 0,
			"pages rewritten by compaction" : 0,
			"row-store internal pages" : 0,
			"row-store leaf pages" : 0
		},
		"cache" : {
			"bytes currently in the cache" : 2015421,
			"bytes read into cache" : 0,
			"bytes written from cache" : 792943,
			"checkpoint blocked page eviction" : 0,
			"data source pages selected for eviction unable to be evicted" : 0,
			"hazard pointer blocked page eviction" : 0,
			"in-memory page passed criteria to be split" : 0,
			"in-memory page splits" : 0,
			"internal pages evicted" : 0,
			"internal pages split during eviction" : 0,
			"leaf pages split during eviction" : 0,
			"modified pages evicted" : 0,
			"overflow pages read into cache" : 0,
			"overflow values cached in memory" : 0,
			"page split during eviction deepened the tree" : 0,
			"page written requiring lookaside records" : 0,
			"pages read into cache" : 0,
			"pages read into cache requiring lookaside entries" : 0,
			"pages requested from the cache" : 20947,
			"pages written from cache" : 29,
			"pages written requiring in-memory restoration" : 0,
			"tracked dirty bytes in the cache" : 0,
			"unmodified pages evicted" : 0
		},
		"cache_walk" : {
			"Average difference between current eviction generation when the page was last considered" : 0,
			"Average on-disk page image size seen" : 0,
			"Clean pages currently in cache" : 0,
			"Current eviction generation" : 0,
			"Dirty pages currently in cache" : 0,
			"Entries in the root page" : 0,
			"Internal pages currently in cache" : 0,
			"Leaf pages currently in cache" : 0,
			"Maximum difference between current eviction generation when the page was last considered" : 0,
			"Maximum page size seen" : 0,
			"Minimum on-disk page image size seen" : 0,
			"On-disk page image sizes smaller than a single allocation unit" : 0,
			"Pages created in memory and never written" : 0,
			"Pages currently queued for eviction" : 0,
			"Pages that could not be queued for eviction" : 0,
			"Refs skipped during cache traversal" : 0,
			"Size of the root page" : 0,
			"Total number of pages currently in cache" : 0
		},
		"compression" : {
			"compressed pages read" : 0,
			"compressed pages written" : 28,
			"page written failed to compress" : 0,
			"page written was too small to compress" : 1,
			"raw compression call failed, additional data available" : 0,
			"raw compression call failed, no additional data available" : 0,
			"raw compression call succeeded" : 0
		},
		"cursor" : {
			"bulk-loaded cursor-insert calls" : 0,
			"create calls" : 3,
			"cursor-insert key and value bytes inserted" : 751426,
			"cursor-remove key bytes removed" : 0,
			"cursor-update value bytes updated" : 0,
			"insert calls" : 20000,
			"next calls" : 120107,
			"prev calls" : 1,
			"remove calls" : 0,
			"reset calls" : 20949,
			"restarted searches" : 0,
			"search calls" : 8,
			"search near calls" : 938,
			"truncate calls" : 0,
			"update calls" : 0
		},
		"reconciliation" : {
			"dictionary matches" : 0,
			"fast-path pages deleted" : 0,
			"internal page key bytes discarded using suffix compression" : 55,
			"internal page multi-block writes" : 0,
			"internal-page overflow keys" : 0,
			"leaf page key bytes discarded using prefix compression" : 0,
			"leaf page multi-block writes" : 1,
			"leaf-page overflow keys" : 0,
			"maximum blocks required for a page" : 28,
			"overflow values written" : 0,
			"page checksum matches" : 0,
			"page reconciliation calls" : 2,
			"page reconciliation calls for eviction" : 0,
			"pages deleted" : 0
		},
		"session" : {
			"object compaction" : 0,
			"open cursor count" : 3
		},
		"transaction" : {
			"update conflicts" : 0
		}
	},
	"nindexes" : 2,
	"totalIndexSize" : 425984,
	"indexSizes" : {
		"_id_" : 192512,
		"num_1" : 233472
	},
	"ok" : 1
}

guugle2010
关注
专栏目录
Mongo Index
方丈的寺院
12-12 2648
摘要 mongo 的索引非常强大，和关系型数据库索引没什么区别。这里主要介绍mongo索引基本知识和mongo本人在索引上的犯的错。 索引种类 单字段索引 复合索引 复合索引各个字段的顺序应该是精确匹配字段(=xxx),排序字段(避免在内存中排序，使用index排序)，范围查询字段 如db.book.find({company: ‘xxx’, age:{$lt:30}).sort(...
mongo索引浅析
m0_37322399的博客
10-17 1045
索引是一种用来方便查询数据的数据结构B Tree就是一种常用的数据库索引数据结构，MongoDB采用 B 树做索引，索引创建在colletions 上。我们可以在这个网站上直观的看到索引的效果。
MongoDB的查询索引
路漫漫其修远兮，吾将上下而求索。
10-31 2550
  目录 为什么要建立索引？ 索引的分类有哪些？ _id索引 单键索引 多键索引 复合索引 过期索引 hello，今天是万圣节
MongoDB 索引
最新发布
qq_62866151的博客
10-01 1271
GeoJSON 是一种基于 JSON (JavaScript Object Notation) 的格式，用于表示各种地理数据结构。它是基于 JSON 的一种标准，用于编码地理信息，包括点、线、面（多边形）以及其他地理集合。GeoJSON 通常用于 Web 地图和地理信息服务中，以便于数据的传输和处理。点（Point）表示一个地理位置上的单个点。线（LineString）表示一系列由线段连接的点。多边形（Polygon）
mongo-索引
面朝大海，春暖花开
03-06 152
mongo索引 准备 假设有一数据库 user [ { "address": { "city": "shanghai", "state": "shanghai", "pincode": "232321" }, "age": 12, "name": "jack", "tags": ["music", "cricket", "blogs"] } ] 索引基本操作 查看索引 删除索引 重建索引 创建索引的参数 查看索引 db
mongo索引
乾复道
07-26 4395
不同于MySQL的索引，mongo的索引是有方向的，value代表了索引的方向，这个特性在排序的使用很好用。就能查看是否使用了索引，以及其他的一些详细信息，包括，使用的索引，扫描的文档数据，结果的数量，查询用时等等。如此我们就建立了一个唯一索引，当然类似MySQL的联合唯一索引mongo也是有的，只需要指定多个字段即可。索引好用，但是切记复合索引是有顺序排列的，如果将查询字段顺序写错，是不会使用索引的哈！需要注意的是，如果集合中包含多个待索引字段是数组，则无法创建复合多键索引。...
mongo索引中的顺序
fajing_feiyue的博客
05-30 1453
我们在使用mongo中可能并未使用排序，但在查询出来数据自动排好序了，或者我们需要使用mongo的自动排序完成一些功能。 1、当无索引的情况下的查询 db.mongoTest2.find({"valueStr2":"nihao2"}); 2、创建索引 db.mongoTest2.ensureIndex({ "valueStr2" : 1, "time" : -1 }, {"name" : "test3_index"}, {"background" : true }); 3、使用索引后的排序 db
关于MongoDB索引管理－索引的创建、查看、删除操作详解
01-19
索引是提高查询查询效率最有效的...MongoDB全新创建索引使用ensureIndex()方法，对于已存在的索引可以使用reIndex()进行重建。 1.1 创建索引ensureIndex() MongoDB创建索引使用ensureIndex()方法。 语法结构 db.COL
ubuntu安装mongodb创建账号和库及添加坐标索引的流程分析
01-19
这里我们梳理一下ubuntu上安装mongodb创建账号和库及添加坐标索引 一 安装 　1.1 安装php-mongodb sudo apt-get install php-mongodb 　1.2 安装mongodb-org sudo apt-key adv --keyserver hkp://keyserver....
mongotemplate 创建索引
05-16
在MongoDB中，可以使用MongoTemplate类来创建索引。MongoTemplate是Spring Data MongoDB库提供的一个类，它提供了一些方便的方法来执行各种MongoDB操作，包括创建索引。 下面是一个使用MongoTemplate创建索引的示例...
【Mongo】创建索引
EDDYCJY的博客
07-20 1334
一、【创建索引】 db.COLLECTION_NAME.ensureIndex({KEY:1},{background: true}) *可选参数列表如下： Parameter Type Description background Boolean 建索引过程会阻塞其它数据库操作，background可指定
Mongo索引大全
lienze.tech
12-23 508
前言 这几年一直在it行业里摸爬滚打，一路走来，不少总结了一些python行业里的高频面试，看到大部分初入行的新鲜血液，还在为各样的面试题答案或收录有各种困难问题 于是乎，我自己开发了一款面试宝典，希望能帮到大家，也希望有更多的Python新人真正加入从事到这个行业里，让python火不只是停留在广告上。 微信小程序搜索：Python面试宝典 或可关注原创个人博客：https://lienze.tech 也可关注微信公众号，不定时发送各类有趣猎奇的技术文章：Python编程学习 索引 索引可以提升文档的查
MongoDB基础之索引详解
上善若泪
11-05 2450
索引通常能够极大的提高查询的效率，如果没有索引，MongoDB在读取数据时必须扫描集合中的每个文件并选取那些符合查询条件的记录。这种扫描全集合的查询效率是非常低的，特别在处理大量的数据时，查询可以要花费几十秒甚至几分钟，这对网站的性能是非常致命的。索引是特殊的数据结构，索引存储在一个易于遍历读取的数据集合中，索引是对数据库表中一列或多列的值进行排序的一种结构由于索引存在于RAM中，所以覆盖索引 从索引中获取数据比通过扫描文档读取数据要快得多MongoDB在MongoDB。
MongoDB——索引
小志的博客
05-02 2934
目录一、索引介绍二、MongoDB索引数据结构2.1、MongoDB索引数据结构是B-Tree还是B+Tree?2.2、MongoDB索引数据结构三、MongoDB索引的分类 一、索引介绍 索引是一种用来快速查询数据的数据结构。 B+Tree就是一种常用的数据库索引数据结构，MongoDB采用B+Tree 做索引，索引创建在colletions上。 MongoDB不使用索引的查询，先扫描所有的文档，再匹配符合条件的文档。 使用索引的查询，通过索引找到文档，使用索引能够极大的提升查询效率。 二、Mongo
MongoDB之索引
热门推荐
ntzzzsj的博客
06-22 1万+
数据库索引类似于图书索引。有了索引便不需要浏览整本书，而是可以采取一种快捷方式，只查看一个有内容引用的有序列表。这使得 MongoDB 的查找速度提高了好几个数量级。
MongoDB索引
qq15035899256的博客
05-08 2497
本文是对MongoDB的学习，先认识了MongoDB的数据存储结构和索引数据结构，又学习了如何创建、查看、删除索引，最后深入学习了索引的多种类型和属性。之后的学习内容将持续更新！！！
3.MongoDB的索引
乐百寿
12-11 2578
一，MongoDB索引简介   索引支持在MongoDB中高效她丸行查询。如果没有索引，MongoDB效页执行全集合扫描，即扫描集合中的每个文档，以选择与查询语句匹配的文档。曲扫描全集合的查询效率是非常低的，特别在处理大量的数据时，查询可以要花费几十秒甚至几分钟，这对网站的性能是着常致命的。如果查询存在适当的索引，MongoDB可以使用该索引限制必须检查的文档数。索引是特殊的数据结构，它以易于遍历的形式存储集合数据集的一小部分。索引存储特定字段或一组字段的值，按字段值排序。索引项的排序支持有效的相等匹配田基
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值