List:General Discussion« Previous MessageNext Message »
From:Toni Strandell Date:September 11 2002 7:06am
Subject:Re: Processing the join
View as plain text  
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
 toni.strandell@stripped



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