SQL Profile
Use this page to review and optimize an SQL statement that you selected through drill-down.
Prerequisite: SQL
tracing must be on to collect the information that is displayed on
this page. On the page, set the Trace State option
to On.
The page displays information about the performance of the SQL statement. The information available depends on the version of the IBM® Informix® database server and the SQL trace settings on the Tracing Admin page.
- Query Info
- Summary statistics about the query.
- Statistics
- Detailed execution statistics about the SQL statement.
- Host Variables
- If any host variables are present in the SQL statement, information about the host variables, including position, data type, and value. Host variables are variables of the host language that are present in SQL statements. A host variable represents a parameter, variable, or field.
- Query Tree
- A visual depiction of the execution plan of the query.
- Optimize
- External directives that apply to the SQL statement.Prerequisites: To add external directives, in the database server configuration file, set the EXT_DIRECTIVES parameter to 1 or 2. To display the table and index names on the Add Directives page for the directives that require these arguments, on the Tracing Admin page, select the Table Names option.
- Add
- Click to display the Add Directives page. Select the directive and specify the table or index arguments if necessary.
- Apply as
- Specify how to apply a directive.
- Active
- Apply the directive to the SQL statement.
- Inactive
- Save the directive, but do not apply it to the SQL statement.
- Test Only
- Apply the directive to the SQL statement only if it is run by user informix or a DBA. Queries by other users will not use this directive.
- Show SQL
- Click to display the SQL statement for the external directives.