leiysky

10 ms·

1. 1.▲
   by leiysky 3y ago

   I agreed with you on the ad-hoc part. The thing is Oracle guys have made significant improvement in MySQL 8.0, including the Volcano-style executor. They also implemented DPhyp join reorder algorithm but with an ad-hoc IR. The join optimize
2. 2.▲
   by leiysky 3y ago

   A fun fact, I was there when I first see them going to put it in use. That’s a pity they finally gave it up. https://github.com/MaterializeInc/materialize/issues/8073
3. 3.▲
   by leiysky 3y ago

   Thanks for reminding, I will update the post later. By the way, the storytelling of Haruki Murakami influenced my a lot, I should have mentioned it when the title first occured to me.
4. 4.▲
   by leiysky 3y ago

   Thanks for your comment. I'm the author of this post. I have been thinking about sharing something about database internals for a long time, but none of my writing ideas was out of cliché then(e.g. introduce some algorithms, summarize