List:General Discussion« Previous MessageNext Message »
From:Toni Strandell Date:September 10 2002 1:45pm
Subject:Processing the join
View as plain text  
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

Thread
mySQL on AIX 4.3.3 problem: errmsg.sys missing?Xiaolin Zhao10 Sep
  • Processing the joinToni Strandell10 Sep
    • Re: Processing the joinBrent Baisley10 Sep
  • Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?Gerald Clark10 Sep
    • Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?Xiaolin Zhao10 Sep
      • Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?Gerald Clark10 Sep
        • Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?Xiaolin Zhao10 Sep
          • Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?Gerald Clark11 Sep
Re: Processing the joinToni Strandell11 Sep
Re: Processing the joinAlec.Cawley11 Sep
Re: Processing the joinToni Strandell11 Sep