Search & Indexing
Autocomplete
As users type in the search box, you must suggest product titles within 50ms. How do you index prefixes, keep suggestions aligned with product visibility in SQL, and avoid scanning the primary DB?
Intermediate drill question.