[TYPO3-dev] Use of subqueries

Martin Kutschker masi-no at spam-typo3.org
Tue Oct 13 09:09:36 CEST 2009


Rik Willems schrieb:
> Hi Masi,
> 
> What exactly do you mean with EXPLAIN?

Mysql will tell you how it executes a query if you put an EXPLAIN before it.

Fire up phpMyAdmin and execute for example this statement:

EXPLAIN SELECT * FROM pages p LEFT JOIN pages_language_overlay plo ON (p.uid=plo.pid)

EXPLAIN helps a lot to check if your queries and indices are efficient! Mysql may surprise you how
it uses your indices and in what order it executes the joins.

See the Mysql docs for more information.

Masi




More information about the TYPO3-dev mailing list