List:Commits« Previous MessageNext Message »
From:Roy Lyseng Date:April 27 2010 1:53pm
Subject:Re: bzr commit into mysql-6.0-codebase-bugfixing branch
(roy.lyseng:3836) WL#5347
View as plain text  

Øystein Grøvlen wrote:
> Roy Lyseng wrote:
>> I mean that both strategies are applicable only when there are no 
>> correlated outer tables, ie all outer tables are non-correlated. 
> 
> I do not think this is correct.  According to the patterns in the 
> description you have added, the patterns of MaterializeLookup is a 
> subset of the patterns for MaterializeScan.

Yes, Guilhem pointed out this as well. I will try to fix it up as much as 
possible, but it may be that the final word is still not said.
> 
>> If there are correlated tables in the suffix, MaterializeScan must be 
>> used. If there are correlated tables only in the prefix, then 
>> MaterializeLookup must be used. 
> 
> I think MaterializeScan can handle correlated tables in the prefix, but 
> the heuristic is to ues MaterializeLookup in this case.

Correct. (ie, if the algorithms were working :)
> 
> -- 
> Øystein
> 

Roy
Thread
bzr commit into mysql-6.0-codebase-bugfixing branch (roy.lyseng:3836) WL#5347Roy Lyseng26 Apr
  • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Guilhem Bichot26 Apr
    • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Roy Lyseng26 Apr
      • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Guilhem Bichot26 Apr
        • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Roy Lyseng28 Apr
      • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Øystein Grøvlen27 Apr
        • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Roy Lyseng27 Apr
  • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Øystein Grøvlen27 Apr
    • Re: bzr commit into mysql-6.0-codebase-bugfixing branch(roy.lyseng:3836) WL#5347Roy Lyseng28 Apr