I am interested in the internal join algorithms, not the join types that can be found in the manual. My question is how the join types in the manual are processed internally? Or, what are the different join algorithms supported by MySQL?
> 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)? -- Toni Strandell [EMAIL PROTECTED] --------------------------------------------------------------------- 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
