backendgym backendgym · reps Sign in with GitHubSign in

02Make the lookup selective

sql-optimizing / reps/02/README.md

Create an index on movies.title, run ANALYZE, and repeat the exact-title plan from rep 1. Also run the query itself, so you see the movie as well as the plan.

Expected: one movie, and usually an Index Scan using your title index. Compare the two execution times, rep 1's and this one.