, 2023 at 8:53 PM "Anitha S" <mailto:anitha...@zohocorp.com>
wrote:
>
>
>
> Hi team,
>
> We have observed that for logically same over clause two different
> window aggregate nodes are created in plan.
> The below query contains two windo
d in
parse tree resulting in the creation of two different window aggregate node.
This check can be modified to form a single window aggregate node for the above
results in faster query execution. Is there any reason for creating two
different window aggregate node?
Thanks
Anitha S
