mongodb-indexing-optimization

name	mongodb-indexing-optimization
version	2.1.0
description	Master MongoDB indexing and query optimization. Learn index types, explain plans, performance tuning, and query analysis. Use when optimizing slow queries, analyzing performance, or designing indexes.
sasmp_version	1.3.0
bonded_agent	04-mongodb-performance-indexing
bond_type	PRIMARY_BOND
capabilities	["index-design","explain-analysis","query-optimization","performance-profiling","esr-rule-application"]
input_validation	{"required_context":["query_pattern","collection_info"],"optional_context":["explain_output","current_indexes","collection_size"]}
output_format	{"index_recommendation":"object","explain_interpretation":"string","performance_impact":"string","trade_offs":"array"}
error_handling	{"common_errors":[{"code":"IDX001","condition":"COLLSCAN in explain output","recovery":"Create index on filter fields following ESR rule"},{"code":"IDX002","condition":"Index not being used","recovery":"Check query shape, hint usage, or index prefix"},{"code":"IDX003","condition":"Too many indexes","recovery":"Review index usage stats, remove unused indexes"}]}
prerequisites	{"mongodb_version":"4.4+","required_knowledge":["basic-queries","explain-command"],"performance_baseline":["Know current query latencies before optimization"]}
testing	{"unit_test_template":"// Verify index is used\nconst explain = await collection.find(query).explain('executionStats')\nexpect(explain.executionStats.executionStages.stage).toBe('IXSCAN')\nexpect(explain.executionStats.totalDocsExamined).toBeLessThanOrEqual(limit)\n"}

MongoDB Indexing & Optimization

Master performance optimization through proper indexing.

Quick Start

Create Indexes

// Single field index
await collection.createIndex({ email: 1 });

// Compound index
await collection.createIndex({ status: 1, createdAt: -1 });

// Unique index
await collection.createIndex({ email: 1 }, { unique: true });

// Sparse index (skip null values)
await collection.createIndex({ phone: 1 }, { sparse: true });

// Text index (full-text search)
await collection.createIndex({ title: 'text', description: 'text' });

// TTL index (auto-delete documents)
await collection.createIndex({ createdAt: 1 }, { expireAfterSeconds: 3600 });

List and Analyze Indexes

// List all indexes
const indexes = await collection.indexes();
console.log(indexes);


 collection.();


 collection.();