RE: Query Plan Analyzer

2012-11-26 Thread Rick James
ore detailed than MySQL's. (But then, it is doing some tricky things.) > -Original Message- > From: Cabbar Duzayak [mailto:cab...@gmail.com] > Sent: Thursday, November 22, 2012 12:45 AM > To: mysql@lists.mysql.com > Subject: Re: Query Plan Analyzer > > Is

Re: Query Plan Analyzer

2012-11-22 Thread Johan De Meersman
- Original Message - > From: "Cabbar Duzayak" > > Is there a way of looking at how mysql builds the query plan and > executes it for a given query? EXPLAIN is definitely a useful tool, but it is > not exact (shows approximations as far as I can see), furthermore I want > something like ho

Re: Query Plan Analyzer

2012-11-22 Thread Cabbar Duzayak
Is this a joke? On Thu, Nov 22, 2012 at 10:20 AM, Zhigang Zhang wrote: > By experience! > > -Original Message- > From: Cabbar Duzayak [mailto:cab...@gmail.com] > Sent: Thursday, November 22, 2012 3:13 PM > To: mysql@lists.mysql.com > Subject: Query Plan Analyzer > > Hi All, > > Is there a

RE: Query Plan Analyzer

2012-11-22 Thread Zhigang Zhang
By experience! -Original Message- From: Cabbar Duzayak [mailto:cab...@gmail.com] Sent: Thursday, November 22, 2012 3:13 PM To: mysql@lists.mysql.com Subject: Query Plan Analyzer Hi All, Is there a way of looking at how mysql builds the query plan and executes it for a given query? EXPLA

Re: query plan

2004-08-23 Thread Egor Egorov
Cao Duy <[EMAIL PROTECTED]> wrote: > How can I get the query plan output? See http://dev.mysql.com/doc/mysql/en/EXPLAIN.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __