← Back to team overview

maria-developers team mailing list archive

Re: better execution plan possible with INNER JOIN of mroonga (or whatever storage engine) ?

 

Hi Sergei !

On 02/12/2014 16:41, Sergei Golubchik wrote:
>> So here are my questions :
>>
>> * can MariaDB request an 'estimation of rows' to mroonga (or whatever
>> storage engine) ?
>> * can such information help to decide a better execution plan with
>> INNER JOIN like above ?
> 
> Yes, I believe it is possible.
> 
> I've reported this issue as a bug now:
> https://mariadb.atlassian.net/browse/MDEV-7250

Thanks for summarising the topic into this issue. It is quite clear and
I could understand the background of the current implementation.
-- 
Kazuhiko Shiozaki, Nexedi SA Senior Consultant
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com/
ERP5: Full Featured High End Open Source ERP
http://www.erp5.com/


References