SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Save Optimized SQL

Use this procedure to save all the current SQL and index-set alternatives and their test results to a file that you can later reload into a SQL Optimizer session.

To save the current SQL and index-set alternatives

Select SQL | Save Optimized SQL.

Unlike a report, which captures information about the current alternatives in your SQL Optimizer session for viewing purposes, this process captures all the information needed to reload the current alternatives into a new session. See the Open Optimized SQL for more information.