AutoNumber slow down performance

[vijaymadhavan28]

Hi All,

I am trying to implement the below SQL script in QlikView to get the latest sequence number and facing performance issue while implementing "AutoNumber"  as an equivalent for rank(). Table contains around 1 Million record.

SQL Script:

select id, response_id, seq_num, create_dt, sent_date,
rank() over(partition by id order by sent_date,response_id) as seq_num
from table_name where seq_num=1;

QlikView Script:

Load
id, response_id, seq_num, create_dt, sent_date,
AutoNumber (RowNo(),id ) as new_seq
from
table_name.qvd(qvd)
where seq_num=1;

Could you please advise on how to overcome the performance issue?

Thanks in advance.

[MarcoWedel · Accepted solution]

see Rob's solution in this thread:

https://community.qlik.com/t5/App-Development/AutoNumber-RowNo-MyField-takes-too-long/m-p/1815069#M6...