Verify the correctness of the rewritten SQL statement by comparing it with the original SQL statement. Use the Run Result function and the Records Returned column of the Run Time pane. This information enables you to see whether the optimized SQL statement provides the same results as the original SQL statement.
Note: The Run Result function is not available for index-set alternatives listed in the Run Time pane.
The Run Result function retrieves the queried records from the connected database.
The Records Returned columns display the number of records influenced by the SQL statement. The figure should remain constant for both the original and optimized SQL statements.