createIndex

Uses

The Liquibase Secure extension for MongoDB includes several modeled Change Types from the Liquibase Open Source version. These let you specify a few MongoDB commands using Liquibase XML, JSON, and YAML changelogs.

createIndex is one such Change Type. You can use it to create an index on an existing collection in your database. This can help you run efficient queries on data that would otherwise be expensive to retrieve.

Note: If you want to specify mongosh statements in your XML, JSON, and YAML changelogs, use the mongo and mongoFile Change Types instead.

Run

To run this Change Type, follow these steps:

1. Add the Change Type to your changeset, as shown in the examples on this page.

2. Specify any required attributes. Use the table on this page to see which ones your database requires.

3. Deploy your changeset by running the update command: liquibase update

Available attributes

For more information, see db.collection.createIndex().

You must specify all top-level attributes marked as required. If you specify an optional attribute, you must also specify any nested attributes that it requires.

keys (required)

A document that defines the index's basic contents and structure. keys has the following nested attributes:

• name (string) (required): the name of a key in the collection to use for the index.

• type (string) (required): the type of the index. For an ascending index, specify 1. For a descending index, specify -1. Other accepted values include text, geospatial, hashed, and more.

options (optional)

A document that defines additional features for the index. options has the following nested attributes:

• unique (Boolean) (optional): if true, creates a unique index so that the collection will not accept the insertion or update of documents where the index key value matches an existing value in the index. Default: false.

• name (string) (required): the name of the index.