Revise · W07 · Day 1Search Fundamentals & Architecture
5:00
Key ideaDay 1 · 1/10
Why LIKE fails
LIKE '%red%' can't use a B-tree, which is sorted by string start, so 50M rows get a full scan. It also has no relevance ranking, typo tolerance, word boundaries, stemming or synonyms.
← → flip · space next / show answer · S shuffle · esc exit1 / 10