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.

Write it as you would say it in the interview: assumptions, the design, tradeoffs, and what you would do next. The draft saves in this browser.

Review the lesson