Interview Question

What is indexing strategy?

Choose indexes from measured query patterns, not from every column.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

An indexing strategy chooses indexes from real query predicates, joins, sorting, and uniqueness rules. • Start with constraints and frequently measured access paths. • Column order matters in multicolumn indexes. • Remove redundant or unused indexes only after checking workload evidence.

💡 SQL Example

CREATE INDEX orders_status_created_idx ON orders (status, created_at);

Result

CREATE INDEX

⚡ Quick Revision

Choose indexes from measured query patterns, not from every column.

←

PreviousWhat is database clustering?

NextWhat is query execution engine?

→