next
Round
Technologies
Experiences
Contribute
Login
next
Round
Technologies
Experiences
Contribute
Login
Question Loading...
Indexing
1. What are indexes?
Level: Expert | Frequency: High
2. How to create Indexes?
Level: Expert | Frequency: High
3. On which filed you will create an index - projection field or filter field?
Level: Expert | Frequency: High
4. What happens if I create an index on all fields of the collection?
Level: Expert | Frequency: High
5. What is the difference between Single Field Indexes & Compound Indexes?
Level: Expert | Frequency: High
6. How to list all indexes?
Level: Expert | Frequency: High
7. How to drop an index?
Level: Expert | Frequency: High
8. What is a 'Covered Query' and how do you design one using Projection?
Level: Expert | Frequency: High
9. Explain the ESR (Equality, Sort, Range) rule. Why is the order of fields in a compound index so critical?
Level: Expert | Frequency: High
10. What is a Sparse Index? Discuss its usage and advantages.
Level: Expert | Frequency: High
11. What is a 'Partial Index' and when would you choose it over a 'Sparse Index'?
Level: Expert | Frequency: High
12. How do indexes affect write performance in a collection that handles 5,000 inserts per second?
Level: Expert | Frequency: High
13. Walk me through the output of .explain('executionStats'). What are the red flags for a senior dev?
Level: Expert | Frequency: High
14. How do you handle 'Index Intersection'? Is it better to have two single-field indexes or one compound index?
Level: Expert | Frequency: High
15. Explain the internal mechanics of a 'Multikey Index'. What happens if you index an array of 1,000 elements?
Level: Expert | Frequency: High
16. How do TTL (Time-To-Live) indexes work and what are their limitations?
Level: Expert | Frequency: High
17. When would you use a Hashed Index vs. a standard B-Tree index?
Level: Expert | Frequency: High
18. You are scraping retail data. You need to query by category (string), sort by price (number), and filter by lastSeen (date range). How do you index this?
Level: Expert | Frequency: High
All Topics
Basics
CRUD
Bulk Operations
Indexing
Data Modelling
Replication
Sharding
Transactions
Aggregation