--

The reason we are using window function without any partition is to add the row_number throughout the dataset and for this example we needed to add the key throughout our dataset which should be continuous and sequential, adding partition key will not help.

And out motto for the article is also same, don't apply window function until it is required.

--

--

Responses (1)