SixK writes:
> - MySql make all joins between tables before extracting the required > rows How do you mean? It can only start returning rows when all tables that are needed have been joined, but of course it doesn't create a temporary table with the product of all tables before it starts to return rows. Try executing a query that would return a billion rows, and get just a few before aborting. Also try joining ten tables with a million (or a billion if you wish) rows each, and look at what the optimizer does (with EXPLAIN). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php