Database Index Simulation
Query 10,000 ShopFlow orders with and without an index; count rows examined and see write costs rise. Interactive data systems simulation, about 6 minutes.
Query 10,000 ShopFlow orders with and without an index; count rows examined and see write costs rise.
Simulation 2 · Data systems · about 6 minutes
What you can do
- Run a query
- Create an index
- Change the WHERE clause
- Insert rows
Related
- Indexes: Fast Reads, Slower Writes — Level 8 · Data Systems
- Storage Engines: B-Trees vs LSM-Trees — Level 8 · Data Systems
- B-Tree vs LSM-Tree — Simulation 1
- Database Internals Lab — Lab