08. B-Tree Indexes in MongoDB: Single Field, Compound & Partial Indexes • MongoDB & NoSQL Architecture: CRUD to Sharding & WiredTiger • Rishabh Ki Kaksha

MongoDB & NoSQL Architecture: CRUD to Sharding & WiredTiger › 08. B-Tree Indexes in MongoDB: Single Field, Compound & Partial Indexes

45 mins

← Prev Next →

Course Syllabus

Module 1: MongoDB Foundations, BSON & CRUD Mechanics

01. NoSQL vs SQL: CAP Theorem & Document-Oriented Architecture 02. BSON Data Types & Document Schema Design (Embedding vs Referencing) 03. High-Performance CRUD Operations, BulkWrite & Write Concerns 04. Schema Validation with JSON Schema ($jsonSchema)

Module 2: Advanced Aggregation Framework & Data Pipelines

05. Aggregation Pipeline Core: $match, $project, $group, $sort & $limit 06. Complex Transformations: $unwind, $lookup (Joins) & $facet (Multi-Facet Analytics) 07. Window Operators ($setWindowFields) & Accumulator Functions

Module 3: Indexing Strategies & Query Optimization

08. B-Tree Indexes in MongoDB: Single Field, Compound & Partial Indexes 09. Special Indexes: TTL (Time-To-Live), Geospatial (2dsphere) & Text Indexes 10. Query Profiling, explain("executionStats") & Index Covering Analysis

Module 4: Storage Engine Internals (WiredTiger) & ACID Transactions

11. WiredTiger Storage Engine Architecture: Cache, Compression & Checkpoints 12. Read Concerns (local, majority, linearizable) & Write Concerns (w:majority, j:true) 13. Multi-Document Distributed ACID Transactions with Sessions

Module 5: High Availability, Replica Sets, Sharding & Backups

14. Replica Sets Architecture: Primary Election, Oplog & Automatic Failover 15. Sharding Architecture: mongos Router, Config Servers & Shard Key Selection 16. Range vs Hash Sharding, Chunk Balancing & Jumbo Chunks Mitigation 17. Change Streams: Building Real-Time Event-Driven Pipelines with MongoDB 18. Production Backup Strategies: mongodump/mongorestore, Point-in-Time & Atlas CLI

Interactive Lesson Studio

# 08. B-Tree Indexes in MongoDB: Single Field, Compound & Partial Indexes

> MongoDB Notes by Rishabh - Topic 08

---

### 1. Indexes Kya Hain? (The Book Index Analogy 📖)

Bina index ke MongoDB ko 10 Million records me se 1 document dhoondhne ke liye **poora disk scan (COLLSCAN)** karna padta hai (5000ms+ lag!).  
**Index (B-Tree Data Structure)** disk par sorted pointers maintain karta hai jisse lookup **O(log N)** time me (< 1ms) execute hota hai!

---

### 2. Compound Indexes & The Golden ESR Rule (Equality, Sort, Range) 👑

Jab multiple fields par compound index banana ho, toh fields ka order kaise decide karein?

```
┌─────────────────────────────────────────────────────────────┐
│                   THE GOLDEN ESR RULE                       │
│ 1. EQUALITY (Exact Match) ➔ 2. SORT ➔ 3. RANGE (>, <, $in)  │
└─────────────────────────────────────────────────────────────┘
```

```javascript
// Query:
db.orders.find({ customerId: "C101", amount: { $gte: 500 } }).sort({ orderDate: -1 });

// ✅ PERFECT INDEX according to ESR Rule:
db.orders.createIndex({
    customerId: 1,  // 1. Equality Field
    orderDate: -1,  // 2. Sort Field
    amount: 1       // 3. Range Field ($gte)
});
```

---

### 3. Partial Indexes (Save 70% RAM ⚡)

Agar 10 Million users me se sirf 100,000 users active hain, toh saare 10M records ko index karke RAM waste kyu karein?

```javascript
// Index only active users:
db.users.createIndex(
    { email: 1 },
    { partialFilterExpression: { isDeleted: false, status: "ACTIVE" } }
);
```

---

### 4. Master Comparison Matrix

| Index Type | Index Definition | Memory Footprint | Best Query Pattern |
| :--- | :--- | :--- | :--- |
| **Single Field** | `{ email: 1 }` | Standard | Simple `findOne({ email })` |
| **Compound (ESR)**| `{ status: 1, date: -1, price: 1 }`| Moderate | Complex multi-filter + sort queries |
| **Partial Index** | `partialFilterExpression: { active: true }`| ⚡ **Tiny (Saves RAM)** | Filtered subset lookups |

---

### 5. Interview Ke 3 Sawal Is Topic Se

1. **Compound Index `{ a: 1, b: 1, c: 1 }` kaunsi queries ko support karega?** -> Prefix rule follow hota hai: `(a)`, `(a, b)` aur `(a, b, c)` queries support hongi; lekin sirf `(b, c)` par ye index trigger nahi hoga.
2. **Index Cardinality ka kya matlab hai?** -> Kisi field me unique values ka ratio; High cardinality fields (jaise `email`, `userId`) par index super-effective hota hai; Low cardinality (jaise `gender`) par index ineffective hota hai.
3. **Index build karte waqt production traffic freeze hone se kaise rokein?** -> MongoDB 4.2+ me saare index builds by default background mode me non-blocking optimized lock ke sath execute hote hain.

---
**Next Topic:** 09. Special Indexes: TTL (Time-To-Live), Geospatial (2dsphere) & Text Indexes

Loading lesson content...

Python 3.12

Full IDE

Live Execution Terminal

Click "Execute Live" to run code.
                

Lesson Mastery AI Quiz

AI Doubt Solver

CERTIFICATE OF COMPLETION

Rishabh Gehlot

PHP 8+ & Laravel 11 Master Track