Чем композитный индекс (a, b, c) отличается от трёх отдельных? Когда leftmost prefix работает, а когда — нет?

Full breakdown is available with Boost

You can read the short answer. The full explanation, code examples, common mistakes, and interviewer prompts unlock with Boost.

• Full answer with the key trade-offs explained
• Code examples and diagrams
• Common mistakes and what the interviewer checks