Is this a joke? On Thu, Nov 22, 2012 at 10:20 AM, Zhigang Zhang <zzgang2...@gmail.com>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 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), > which indexes were used, etc. > > Basically, Oracle's EXPLAIN PLAN and SQL TRACE do this, and it is very very > useful for optimizing queries. Don't get me wrong, I love mysql, but with > mysql, you optimize queries more by trial and error, instead of > understanding what exactly is going on. > > Thanks a ton. > >