Op 27-aug-2007, om 9:54 heeft Paul J Stevens het volgende geschreven:
Then why do I keep hearing noises on this list that JOINs are faster than sub-SELECTS ??
It depends on the amount of data returned from the subselect. Subselects in general are executed first and put in an temporary table. If this temporary table is large, the subselect will be much slower than the JOIN.
A join can be slower if the WHERE fields are put in wrong order. _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
