Row_num() performance

Database
N/A

Row_num() performance

SQL using the QUALIFY_ROW_NUMBER() function are always consuming more resources than before the TD 12 upgrade and sometimes taking longer to execute.
Is this known issue? Is there any way to impvove the performance.