Drop an index

javascript

db.orders.dropIndex({ status: 1, created_at: -1 })

Explanation

Every index speeds some reads but adds write and storage cost, so removing unused ones can help.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Explain and tune

Test how a query behaves with a chosen index.

Open In sheetjavascriptsame section

Temporarily hide an index from the planner.

Open In sheetjavascriptsame section

Show the execution plan for a `find()` query.

Open In sheetjavascriptsame section

View storage and index metrics for a collection.

Open In sheetjavascriptsame section

Inspect existing indexes.

Open In sheetjavascript2 tag match

Index one frequently filtered field.

Open In sheetjavascript1 tag match