Your custom process is slow after an upgrade.
The process has gel script which has a SQL that took the majority of the time
The join with “PPA_TRANSCONTROL” table is causing the query to take a lot of time.
Release : 15.9.2
Component : Clarity Studio
Resolved in 16.0.3
The query ran faster after creating an index in “EXTERNAL_ID” column in “PPA_TRANSCONTROL” table.