PROTECTED]
Sent: Friday, November 03, 2006 1:40 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Analysis Tool
H. I actually think this would be somewhat difficult to write,
Robert. Parsing the queries would be complex enough given the different
ways one can construct SQL
H. I actually think this would be somewhat difficult to write,
Robert. Parsing the queries would be complex enough given the
different ways one can construct SQL. Also it would have to examine
the cardinality of the data in each column to determine if indexing
would be worthwhile vs. a tabl
I'm looking for a tool that could parse a boat load of various queries
using complex joins and subqueries, analyze each, and print out the
optimal covering indices that could be used on each table for each
query. It would have to take into consideration stuff like a WHERE
expression that could not
