Re: Top-down pass of an optimized plan

2019-11-12 Thread Serafeim (Makis) Papadias
zed plan. Top-down or Bottom-up can also be specified. > Many systems have this kind of post processing phase. > > - Haisheng > > ------ > 发件人:Serafeim (Makis) Papadias > 日 期:2019年11月13日 05:37:37 > 收件人: > 主 题:Top

Top-down pass of an optimized plan

2019-11-12 Thread Serafeim (Makis) Papadias
Dear all, I am performing a Volcano optimisation pass first and I receive the root of the optimised plan from the standard Program in [1]. Afterwards, I want to perform a top-down pass to the optimised plan and change it a bit by placing certain operators at specific points. Do you have any

Different performance of the same code in two laptops

2019-10-15 Thread Serafeim (Makis) Papadias
Hello everyone, I am experimenting with rules and volcano optimiser lately and I am facing something weird. I run my code through Intellij IDE. The databases are set the same way in both machines and since I care only about query rewriting for now I just read the table schemas from the