answer.sql was generated to find the one movie titled The Quiet Harbor. Read it first, then run it and compare with the expected result below. Fix the file.
Expected once fixed: 1 row. The shipped query returns 2.
← SQL · Optimizing
3 of 8
03Judge a title lookup
sql-optimizing / reps/03/README.md
- 1 Which predicate made the lookup match more than one title, and which row gave it away?
-
2
Run
EXPLAINon the shippedLIKE. Did rep 2's index serve it, and what does your database's collation have to do with that?