Performance Issue with Record Type Default Filter Using Expression in Appian Health Check

Hi Appian Community,

We recently ran a Health Check on our application and encountered a performance finding related to a Record Type. The specific issue is with the "Data Query and Default Filter" step, which is taking 4322 ms to execute.

Context:

• We have a Record Type (recordType!ABC) that pulls data from a database view containing all case types.
• A default filter is applied using the "Expression" option.
• The expression used is:

a!queryFilter(

  field: 'recordType!ABC.fields.transactionId',

  operator: "=",

  value: 46

)

Note: The transactionId field is indexed in the main underlying table

Any insights or recommendations would be greatly appreciated!