Hi Julian Sorry for the late reply. What I mean CTE here stands "Common Table Expressions", aka with clause. The main optimization about this is to decide whether to inline CTE or not(materialize CTE to reuse, if the query uses it multi-time) in a CBO way. More details can be seen in this paper(Orca team published): Optimization of Common Table Expressions in MPP Database Systems
Regards! Aron Tao Julian Hyde <[email protected]> 于2021年4月28日周三 上午2:44写道： > Can you define CTE? (I know of a few concepts that could be described as > such.) Give an example SQL query and the kind of optimization you had in > mind. > > > On Apr 27, 2021, at 6:51 AM, JiaTao Tao <[email protected]> wrote: > > > > Seems we have very limited optimize about CTE current, do we have any > plan > > to improve this? > > > > > > Regards! > > > > Aron Tao > >
