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

Question

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!

Shubham Aware · Answer

Try to do this basic changes to avoid delay in execution.

Ensure the database view isn't complex enough to prevent index usage on transactionId.
Remove unnecessary fields from the Record Type to minimize data load.
Use Query Preview(Performance) in expression to verify execution time and optimize further.
If possible, enable paging to avoid loading all records at once.