Is this a joke? On Thu, Nov 22, 2012 at 10:20 AM, Zhigang Zhang <[email protected]>wrote:
> By experience! > > -----Original Message----- > From: Cabbar Duzayak [mailto:[email protected]] > Sent: Thursday, November 22, 2012 3:13 PM > To: [email protected] > 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. > >
