Single Field Indexes

Overview

Single field indexes are indexes with a reference to a single field of a document in a collection. These indexes improve single field query and sort performance. They also support TTL Indexes that automatically remove documents from a collection after a certain amount of time or at a specified clock time.

When creating a single field index, you must specify the following details:

• The field on which to create the index

• The sort order for the indexed values as either ascending or descending

database = client.use('sample_mflix')
collection = database[:movies]

Create a Single Field Index

Use the create_one method to create a single field index. The following example creates an index in ascending order on the title field:

# Creates an index on the "title" field
collection.indexes.create_one({ title: 1 })

Verify Index Creation

You can verify that the index was created by listing the indexes in the collection. You should see an index for title in the list, as shown in the following output:

# Lists all indexes on the collection
puts collection.indexes.collect(&:to_json)

{"v": 2, "key": {"title": 1}, "name": "title_1"}

Example Query

The following is an example of a query that is covered by the index created on the title field:

# Finds a document with the title "Sweethearts" by using the newly created index
filter = { title: 'Sweethearts' }
doc = collection.find(filter).first
if doc
 puts doc.to_json
else
 puts "No document found"
end

{"_id":...,"plot":"A musical comedy duo...",
"genres":["Musical"],...,"title":"Sweethearts",...}

Additional Information

To view runnable examples that demonstrate how to manage indexes, see Optimize Queries by Using Indexes.

To learn more about single field indexes, see Single Field Indexes in the MongoDB Server manual.