Zwei Queries ... äquivalent?

[Peter Thomassen]

Tach,

"Replace a join with a subquery. For example, use this query:

...

Ebenfalls http://dev.mysql.com/doc/mysql/en/Optimising_subqueries.html.

These tricks might cause programs to go faster or slower. Using MySQL facilities like the BENCHMARK() function, you can get an idea about what helps in your own situation.

Hm... warum steht das unter "Optimising Subquerise"? :-)

Grüße aus Würzburg,
Peter