Meituan Technology Team

Mar 9, 2017 · Databases

SQLAdvisor: An Open-Source SQL Optimization Tool from Meituan-Dianping

SQLAdvisor, an open-source MySQL optimization utility from Meituan-Dianping, analyzes a given SQL statement—parsing its lexical structure, WHERE clauses, field selectivity, aggregations and multi-table joins—to automatically recommend missing indexes, supporting INSERT/DELETE/UPDATE/SELECT operations, filtering existing indexes, and inviting community contributions on GitHub.