Tell us about your database:

Please submit the query you would like to optimize:

Most of our advanced optimization algorithms require extra metadata from your database to effectively optimize this query (for example: the schema's structure, columns data distribution, etc.).

Read here how to quickly fetch this metadata using your favorite SQL IDE.
Once you got the metadata in a file, please upload the file here below:

* The information you provide is encrypted and protected. Learn more on our security page.

As a last step and to provide the most optimal recommendations, we need some extra metadata.
Please execute this query on your database using your SQL IDE and copy the output:

  Copy(SELECT 
	CAST(CONCAT('{"columns": [',@cols,'], "indexes": [',@indexes,'], "tables":[',@tbls,']}') AS CHAR) as metadata_json
FROM
    (SELECT (@cols:=NULL),
            (SELECT (0) FROM information_schema.columns cols
             WHERE table_schema not in ('mysql','information_schema', 'sys', 'performance_schema')
                  AND (0x00) IN (@cols:=CONCAT_WS(',', @cols, CONCAT('{"schema":"',cols.table_schema,'","table":"',cols.table_name,'","name":"', cols.column_name, '","type":"', cols.column_type, '","nullable":', IF(cols.IS_NULLABLE = 'YES', 'true', 'false'), ',"collation":"', IFNULL(cols.COLLATION_NAME, ''), '"}'))))
    ) cols,
    (SELECT (@indexes:=NULL),
            (SELECT (0) FROM information_schema.statistics indexes
             WHERE table_schema not in ('mysql','information_schema', 'sys', 'performance_schema')
                  AND (0x00) IN (@indexes:=CONCAT_WS(',', @indexes, CONCAT('{"schema":"',indexes.table_schema,'","table":"',indexes.table_name,'","name":"', indexes.index_name, '","column":"', indexes.column_name, '","cardinality":', indexes.cardinality, '}'))))
    ) indexes,
    (SELECT (@tbls:=NULL),
            (SELECT (0) FROM information_schema.tables tbls
             WHERE table_schema not in ('mysql','information_schema', 'sys', 'performance_schema')
                  AND (0x00) IN (@tbls:=CONCAT_WS(',', @tbls, CONCAT('{', '"schema":"', `TABLE_SCHEMA`, '",', '"table":"', `TABLE_NAME`, '",', '"rows":', `TABLE_ROWS`, ',', '"engine":"', `ENGINE`, '",', '"collation":"', `TABLE_COLLATION`, '"}'))))
    tbls) x);

Please copy the output of the query from your SQL IDE and paste it here: