[TYPO3-dev] Use of subqueries

[Rik Willems]

Hi Masi,

What exactly do you mean with EXPLAIN?

Greets, Rik


Martin Kutschker wrote:
> Bernhard Kraft schrieb:
>> It depends on what you want to achieve. In many cases it is also
>> possible to avoid subqueries by clever use of "JOIN" or "LEFT JOIN".
> 
> And be sure to check the output of EXPLAIN for both queries. Depending on your query, your indices
> and the number of rows in the tables one version may be faster. I don't think that sub-queries are
> slower in all circumstances.
> 
> Masi