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), furthermor

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 >

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

Query Plan Analyzer

2012-11-21 Thread Cabbar Duzayak
Hi All, 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 how the predicates were applied (before or after JOINS

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.e

query plan

2004-08-23 Thread Cao Duy
Hi all, How can I get the query plan output? thanks alot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]