The Get database measures command is an informative feature that provides information about the 4D database engine events.

One detail returned from the command is about the queries performed. The "queries" attribute contains an array of objects with one of the attributes being "queryStatement". Typically this object will contain the query string with the field names, but sometimes it can contain "4D language expression", such as the following:

   "quesryStatement" : "4D language expression"

This means that the query performed was a sequential query in which 4D's engine could not execute directly and instead had to loop through all of the records and perform the formula once per record.

For example this would occur with a call similar to:
QUERY BY FORMULA(...;Substring(Myfield;5;10))