README
¶
文档 | FAQ | 变更记录 | 路线图 | English
SOAR
SOAR(SQL Optimizer And Rewriter) 是一个对 SQL 进行优化和改写的自动化工具。 由小米人工智能与云平台的数据库团队开发与维护。
功能特点
- 跨平台支持（支持 Linux, Mac 环境，Windows 环境理论上也支持，不过未全面测试）
- 目前只支持 MySQL 语法族协议的 SQL 优化
- 支持基于启发式算法的语句优化
- 支持复杂查询的多列索引优化（UPDATE, INSERT, DELETE, SELECT）
- 支持 EXPLAIN 信息丰富解读
- 支持 SQL 指纹、压缩和美化
- 支持同一张表多条 ALTER 请求合并
- 支持自定义规则的 SQL 改写
快速入门
交流与反馈
- 欢迎通过 Github Issues 提交问题报告与建议
- QQ 群：779359816（未满） 758940447（已满）
- Gitter 推荐
License
Documentation
Source Files
Directories
¶
| Path | Synopsis |
|---|---|
|
Package advisor contain heuristic rules, index rules and explain translator.
|
Package advisor contain heuristic rules, index rules and explain translator. |
|
Package ast is an interface for Abstract Syntax Tree parser
|
Package ast is an interface for Abstract Syntax Tree parser |
|
cmd
|
|
|
soar
Package soar is the main program of SOAR
|
Package soar is the main program of SOAR |
|
Package common contain many useful functions for logging, formatting and so on.
|
Package common contain many useful functions for logging, formatting and so on. |
|
Package database will take cover of communicate with mysql database.
|
Package database will take cover of communicate with mysql database. |
|
Package env contain virtual database build, rehash, cleanup.
|
Package env contain virtual database build, rehash, cleanup. |
Click to show internal directories.
Click to hide internal directories.