How to Drop all the indexes in a Collection using PyMongo?

In PyMongo, the drop_indexes() method is used to remove all non-default indexes from a collection. It helps developers clean up or reset indexing strategies, especially during optimization or testing. The method retains the default _id index, which cannot be dropped.

Syntax

collection.drop_indexes()

Note: drop_indexes() method does not take any parameters, it simply removes all indexes on the collection.

Sample database used:

Viewing Existing Indexes

By default, every MongoDB collection has an index on the _id field to uniquely identify each document. Even if you delete all other indexes, the _id index will still remain and cannot be removed.

To list all current indexes on a collection, run:

Where,

• key: Field used for indexing.
• name: Name of the index.
• ns: Namespace (i.e., Database.Collection).

Example 1:

This code creates an index on the l_id field. It then prints the auto-generated name of the new index and displays all indexes present in the collection using index_information().

Output

Example 2:

In this Example all indexes are removed except default _id index using the drop_indexes() method, then prints the remaining indexes using index_information().

Output

Related Articles:

• Indexing in MongoDB
• Creating Index in MongoDB
• Rebuilding all Indexes in MongoDB
• Get all Information of index