That query is an update query that has passed parameters which are going to be set.

The where clause is based on primarykey, by using the passed ID.

I don't see anything that can be tune for the query. The update is based on a table that has a million records.

So maybe a data purge of some historical data may help?

Thanks,