QOT is a tool to generate optimal indexes for SELECT queries. Other QOT features include query rewrites, SQL static checking, error reporting, and query reverse engineering.
| Tags | Database |
|---|---|
| Licenses | GPLv2 |
| Operating Systems | POSIX Linux |
| Implementation | C++ |
Recent releases


Changes: This release ORDER BY analysis for index generation, an ORDER BY-specific rewrite (const-field removal), ORDER BY-specific static checks, table and field alias support, and improved error reporting. A segfault if query-file doesn't start with create database and use commands general was fixed along with a segfault for queries that use table alias. A crash with bigint, datetime, and enum field types was fixed. The covering index generation algorithm was fixed.


Changes: This release has query analysis, index generation, and simple rewrites.