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.
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.
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.
