It depends on your database & query structure and especially what indexes are available. If you just put "explain" in front of your query you will be able to see how mysql will execute your query.
On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote: > > 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 <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 --------------------------------------------------------------------- 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
