Optim Performance Manager gathers and aggregates performance data for SQL statements that are issued from an application and that are run on a database that is monitored by Optim Performance Manager. You can import SQL performance data from the Optim Performance Manager repository database and display the data for the SQL statements in the SQL Outline view. To retrieve the data from a repository database, you create an Optim Performance Manager profile that defines the connection to a repository database.
The following illustration shows how the workbench imports the SQL performance data that is gathered by Optim Performance Manager.
In the SQL Outline view, the Optim Performance Manager data is displayed only for the SQL statements that are listed in the view. If performance data is imported for SQL statements that are not in the view, that data is not displayed. When data is displayed, the data is displayed on the row that lists the SQL statement without a line number. The imported data does not contain the information to match the performance data to a specific SQL statement at a source code line number. If the SQL statement is listed more than once, the same performance information is displayed for each occurrence of the statement.