Architect

Jul 16, 2023 · Databases

How Meituan Merges Cost‑Based and AI‑Driven Index Recommendation for Billions of Slow Queries

Facing over a hundred million daily slow queries, Meituan’s Database Autonomous Service combines traditional cost‑based index selection with an AI‑powered, data‑driven classifier to automatically generate and validate missing indexes, achieving a 12.16% uplift in index adoption and saving thousands of hours of query execution time.