Re: [Maria-developers] 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/