How does MySQL process a join between tables? Does it always use nested-loop join, or does it use sort-merge join if the table is sorted before joining it? Is the join algorithm merge if the tables are already sorted on the join attributes (through an index)?
Sincerely, Toni Strandell --------------------------------------------------------------------- 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