Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Release Notes

Verify the Correctness of Optimized SQL

Verify the Correctness of Rewritten SQL

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.

Run Result

The Run Result function retrieves the queried records from the connected database.

Records Returned

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating