Re: about optimization rules for over(partition by id, age order by id, age)

ld be either a planner rule or a rewrite by RelBuilder. > > Julian > > > > On Feb 21, 2024, at 11:43 PM, key lou wrote: > > > > HI ALL : > > I have the following sql: > > select name, row_number() over(partition by id, age order by id, age) rn > &g

about optimization rules for over(partition by id, age order by id, age)

HI ALL : I have the following sql: select name, row_number() over(partition by id, age order by id, age) rn from t; In fact, it can be optimized into select name ,row_number() over(partition by id,age) rn from t; Remove order by because order by and partition by are repeated. Since they are grou