- Setup SQLite or PostgreSQL and load sample data using
baseline_queries.sql. - Run baseline query and note execution plan.
- Apply index from optimized_queries.sql and run optimized query.
- Compare execution plans and timings.
- See docs/performance_report.md for details.
Commands example for SQLite: sqlite3 test.db < baseline_queries.sql sqlite3 test.db < optimized_queries.sql