According to Appian best practices, which code snippet accomplishes this goal in the most efficient way?

You have a record type, ABC_Author, backed by a database table.

You need to retrieve the total number of authors without loading all the data.

According to Appian best practices, which code snippet accomplishes this goal in the most efficient way?

A)

B)

C)

A . Option A
B . Option B
C . Option C

View Answer

Answer: B

Explanation:

According to Appian best practices, the most efficient way to retrieve the total number of authors without loading all the data is to use a query that includes an aggregation function. Option B uses an aggregation field with a COUNT function, which is designed to return the number of rows that match a query without the need to retrieve and load all row data, thus optimizing performance.

Reference: Appian Documentation: a!queryRecordType Function