Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MeehyeOh
Partner - Creator
Partner - Creator

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.

Reply, Thanks!

Labels (1)
1 Reply
Pierrick
Partner - Contributor III
Partner - Contributor III

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.