In MongoDB, if collection is dropped, indexes dropped automatically as well?

mongodb collections indexing document
raffian picture raffian · Dec 14, 2011 · Viewed 13.2k times · Source

If I create a collection in Mongo, and after adding documents to this collection I use ensureIndex() to create an index on, say, a number field on a document in this collections, if I drop the collection, do I have to recreate the index?

Answer

lig picture lig · Dec 14, 2011

Short answer: yes.

Indexes are dropping on collection drop. You need to recreate an index.

You may want to not to drop collection but remove all items in it with db.collection_name.remove({}). It will take more resources but leave your indexes. Actually it will need to delete all index data. That is why it is more preferred to drop the whole collection and recreate indexes after that.

Related questions

MongoDB Show all contents from all collections

Is it possible to show all collections and its contents in MongoDB? Is the only way to show one by one?

Read More
How can I rename a collection in MongoDB?

Is there a dead easy way to rename a collection in mongo? Something like: db.originalCollectionName.rename('newCollectionName'); And if not, what is the best way to go about effectively renaming one?

Read More
Get position of selected document in collection [mongoDB]

How to get position (index) of selected document in mongo collection? E.g. this document: db.myCollection.find({"id":12345}) has index 3 in myCollection myCollection: id: 12340, name: 'G' id: 12343, name: 'V' id: 12345, name: 'A' id: 12348, name: 'N'

Read More