QOT QOT (Query analysis and Optimization Tool) is MySQL DBAs intelligent assistant.
Download

QOT Ranking & Summary

QOT Tags

database MySQL DBA MySQL DBA intelligent assistant query analysis

QOT Description

QOT (Query analysis and Optimization Tool) is MySQL DBAs intelligent assistant. QOT (Query analysis and Optimization Tool) is MySQL DBAs intelligent assistant. Using QOT you can optimize you queries build optimal indexes, perform SQL static checking and more.Installation:The simplest way to compile this package is:1. `cd' to the directory containing the package's source code and type `./configure' to configure the package for your system. If you're using `csh' on an old version of System V, you might need to type `sh ./configure' instead to prevent `csh' from trying to execute `configure' itself.Running `configure' takes awhile. While running, it prints some messages telling which features it is checking for.2. Type `make' to compile the package.3. Optionally, type `make check' to run any self-tests that come with the package.4. Type `make install' to install the programs and any data files and documentation.5. You can remove the program binaries and object files from the source code directory by typing `make clean'. To also remove the files that `configure' created (so you can compile the package for a different kind of computer), type `make distclean'. There is also a `make maintainer-clean' target, but that is intended mainly for the package's developers. If you use it, you may have to get all sorts of other programs in order to regenerate files that came with the distribution.Usage: qot Options: --help Print this message --info Print summary information about every query --input-file=< path > Read DDL and queries from the file. You can specify this option more than once in which case the files are read in the order of their appearance on the command line --input-query=< string > Read DDL and queries from the string. You can specify this option more than once, in which case the strings are read in the order of their appearance on the command line If both --input-file and --input-query options are present, then the file(s) is/are read first --output-mode=< mode > Output mode can be one of: xml, sql, text. --propose=< item > For all the queries from the input perform propose of < item > and print optimized < item >'s SQL. < item > is one of: index, cov-index, merged-index. --rewrite=< item > For all the queries perform rewrite of the < item > and print the modified version of the < item >'s SQL. At the moment < item > can be only expand-stars which means replacing * wildcards in the select items list. --static-checks Perform query static checks --version Print version and copyright infoWhat's New in This Release:· 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.

QOT Related Software