When update statement, the execute time sometime taking 60 second sometimes taking 1-2 sec. Total row count around 18 million. CARDID is our PK. Almost each 2-3 sec our system send a request to that query. You can find the query on below;