List:General Discussion« Previous MessageNext Message »
From:Sinisa Milivojevic Date:October 24 2001 2:08pm
Subject:Re: Query Analyzer
View as plain text  
Moshe Gurvich writes:
> Are there tools for MySQL like MS SQL Query Analyzer, that can analyze and
> estimate effectivity of a query?
> 
> Or is it possible to approximate execution plan of queries that will be run
> on MySQL with above mentioned utility?
> 
> Thank you.
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001
> 
> 
> 

Hi!

In order to find out how MySQL will process a query, run EXPLAIN on
the query.

If you would like to know how to improve stuff, add "..procedure
analyse" at the end of your query.

-- 
Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com

Thread
Query AnalyzerMoshe Gurvich24 Oct
  • Re: Query Analyzerjoseph.bueno24 Oct
  • Re: Query AnalyzerSinisa Milivojevic24 Oct