Which command is used to show the current indexes of a collection?

Which command is used to show the current indexes of a collection?

• A. db.collection.showIndexes()
• B. db.collection.getIndexes()
• C. db.collection.listIndexes()
• D. db.collection.displayIndexes()

Answer: (B)

The command that is used to show the current indexes of a collection is `db.collection.getIndexes()`. This command retrieves an array of documents representing the indexes defined for a specific collection in a MongoDB database. Using `getIndexes()` provides detailed information about each index, including its name, key pattern, and creation timestamp, which is crucial for understanding how data is organized and optimized in the collection for query performance. The other choices do not represent valid MongoDB commands for retrieving index information. Therefore, the focus on the correct command reinforces the importance of understanding the appropriate syntax and functions available within MongoDB for effective database management.

The command that is used to show the current indexes of a collection is db.collection.getIndexes(). This command retrieves an array of documents representing the indexes defined for a specific collection in a MongoDB database.

Using getIndexes() provides detailed information about each index, including its name, key pattern, and creation timestamp, which is crucial for understanding how data is organized and optimized in the collection for query performance.

The other choices do not represent valid MongoDB commands for retrieving index information. Therefore, the focus on the correct command reinforces the importance of understanding the appropriate syntax and functions available within MongoDB for effective database management.