YouTip

# MongoDB Indexing Indexes can significantly improve query efficiency. Without indexes, MongoDB must scan every document in the collection and select those that match the query criteria when reading data. This full collection scan is very inefficient, especially when dealing with large amounts of data. Queries may take tens of seconds or even minutes, which is detrimental to website performance. Indexes are special data structures that store a sorted collection of data for easy traversal and reading. They are a structure for sorting the values of one or more columns in a database table. In MongoDB, common index types include: * **Single-field index**: An index based on a single field. * **Compound index**: An index based on a combination of multiple fields. * **Text index**: Used to support full-text search. * **Geospatial index**: Used for querying geospatial data. * **Hashed index**: An index that hashes field values. * * * ## Creating Indexes MongoDB uses the `createIndex()` method to create indexes. > Note: Before version 3.0.0, the method to create indexes was `db.collection.ensureIndex()`. Later versions use `db.collection.createIndex()`. `ensureIndex()` is still usable but is just an alias for `createIndex()`. ### Syntax The basic syntax format of the `createIndex()` method is as follows: db.collection.createIndex( keys, options ) * `db`: Reference to the database. * `collection`: Name of the collection. * `keys`: An object specifying the field name and the sort direction of the index (1 for ascending, -1 for descending). * `options`: An optional parameter that can contain additional options for the index. The `options` parameter is an object that can contain various configuration options. Here are some commonly used options: * `unique`: If set to `true`, creates a unique index, ensuring that the values of the indexed field are unique within the collection. * `background`: If set to `true`, the index creation process runs in the background without affecting other database operations. * `name`: Specifies the name of the index. If not specified, MongoDB automatically generates a name based on the indexed fields. * `sparse`: If set to `true`, creates a sparse index that only indexes documents that contain the indexed field. * `expireAfterSeconds`: Sets the expiration time for the indexed field. MongoDB will automatically delete expired documents. * `v`: Index version, usually does not need to be set manually. * `weights`: Specifies weights for text indexes. ## Examples // Create an ascending index on the age field db.myCollection.createIndex({ age:1}); // Create a text index on the name field db.myCollection.createIndex({ name:"text"}); ### Examples Index creation: ## Examples // Create a unique index db.collection.createIndex({ field:1},{ unique:true}) // Create an index that runs in the background db.collection.createIndex({ field:1},{ background:true}) // Create a sparse index db.collection.createIndex({ field:1},{ sparse:true}) // Create a text index and specify weights db.collection.createIndex({ field:"text"},{ weights:{ field:10}}) Create a geospatial index For fields storing geographic location data, you can use the `2dsphere` or `2d` index types to create geospatial indexes. // 2dsphere index, suitable for spherical geographic data db.collection.createIndex({ location:"2dsphere"}) // 2d index, suitable for flat geographic data db.collection.createIndex({ location:"2d"}) ### Creating a Hashed Index Starting from MongoDB version 3.2, you can use hashed indexes to hash fields, supporting large-range numeric lookups. db.collection.createIndex( { field: "hashed" } ) ### Viewing Indexes You can use the `getIndexes()` method to view all indexes in a collection: db.collection.getIndexes() ### Deleting Indexes You can delete indexes using the `dropIndex()` or `dropIndexes()` methods: ## Examples // Delete a specific index db.collection.dropIndex("indexName") // Delete all indexes db.collection.dropIndexes() ### Indexing Strategies When creating indexes, consider the following factors: * **Query Frequency**: Prioritize fields that are frequently used in queries. * **Field Cardinality**: The higher the cardinality of field values (i.e., the more unique values), the better the index performance. * **Index Size**: The size of the index affects the database's memory usage and query performance. ### Index Optimization When optimizing indexes, consider the following methods: * **Choose the Right Index Type**: Select the appropriate index type based on query requirements. * **Create Compound Indexes**: For fields that are often used together, consider creating compound indexes to improve query efficiency. * **Monitor Index Performance**: Regularly monitor index usage and adjust indexes based on actual needs. ### Notes * While indexes can improve query performance, they also increase the overhead of write operations. Therefore, when creating indexes, you need to balance query performance and write performance. * Indexes consume additional storage space, especially for large datasets, so consider the storage cost of indexes. By designing and using indexes reasonably, you can significantly improve the query performance and response speed of MongoDB databases, thereby better supporting application needs.