On Mon, 2008-12-08 at 23:23 +0000, ceo@xxxxxxxxx wrote: > Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-query and kick things back out to the outer query. > > > > IN has to process them all and find them all. > > > Don't forget the special case use as well: IF NOT EXISTS `universe` THEN bigbang() Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php