New array query performance

Suppose we re-use the same Service Manager expert search from the Search Interaction Records form.

assignment.groups="Application"

Service Manager generates a new SQL statement that joins the main and alias tables:

SELECT m1."NAME" FROM HPOPERATORM1 m1 JOIN HPOPERATORA6 a6 ON (m1."NAME" = a6."NAME") WHERE ((a6."ASSIGNMENT_GROUPS"='Application'));

The join statement requires some additional system resources that the old query did not, however since the ASSIGNMENT_GROUPS column is now a simple character data type, the RDBMS can query the field directly. While the query still returns the same 18 sample operator records, this time it does not have to forward any rows to Service Manager for evaluation. Nor does running this query generate performance warning messages. This means that the new query is more efficient despite the added overhead of a join statement.

Related concepts

Existing array mapping
Existing array query performance
Prepare to remap the array
New array mappingNew array query performance