Ken Menzel writes: > Hi Guys, > I would like to request an additional feature with EXPLAIN. > EXPLAIN does not run the query guesses on how the query would be run. > This is not always accurate. The slow-log however logs the actual > information the query was run with (like explain only the truth!). > Could we have an option with EXPLAIN to actually run the query and > provide the true results? > Maybe REXPLAIN, or EXPLAIN RUN query? > > Thanks Ken > ----------------------------------------------------- > Ken Menzel ICQ# 9325188 > www.icarz.com [EMAIL PROTECTED] >
Hi! This is of course doable, but EXPLAIN will be more accurate if all tables involved were ANALYZE'd ... -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php