Which feature consumes more resources, Window function or Group by?
Hi,
I've been using it very well since the Window function was added. I wonder if the window function or the group by consumes more resources. And what functions perform faster when loading data? I don't know the difference because my test data capacity is small.
Hi ! At the moment, it seems to me the window function is a little slower and uses slightly more power than group by. The difference is noticeable with large volumes of data or repeated use.