Indexes

Databasesdb

The Question

How do database indexes work and when should you use them?

What a Strong Answer Covers

• B-tree
• read/write tradeoff.

Related Questions

• ACID
• Clustered vs Non-clustered
• Isolation Levels
• Normalization
• PostgreSQL Internals — MVCC, WAL, VACUUM