View Brian Mansell's profile
MySQL: EXPLAIN EXTENDED
2007-11-08
In this older article, Peter Zaitsev (a MySQL guru) explains a somewhat rarely discussed feature introduced in MySQL 4.1 known as the Extended Explain.
One nice feature added for EXPLAIN statement in MySQL 4.1 is EXTENDED keyword which provides you with some helpful additional information on query optimization. It should be used together with SHOW WARNINGS to get information about how query looks after transformation as well as what other notes optimizer may wish to tell us. It is best seen by example...
Labels: mysql
posted by Brian Mansell @ 8:39:00 AM,
