Optimize SQL
The Optimize SQL function analyzes the input SQL statement and uses an Artificial Intelligence Engine to produce a group of semantically equivalent versions of the statement, known as SQL alternatives. You can then test run these alternatives in the SQL Optimizer window to determine the best-performing version of the SQL.
Note: The Intelligence Level setting you select affects the duration of the optimization process and the number of alternatives SQL Optimizer generates.
About Optimizing SQL
The Optimize SQL function analyzes the input SQL statement and uses an Artificial Intelligence Engine to produce a group of semantically equivalent versions of the statement, known as SQL alternatives. You can then test run these alternatives in the SQL Optimizer window to determine the best-performing version of the SQL.
Note: The Intelligence Level setting you select affects the duration of the optimization process and the number of alternatives SQL Optimizer generates.
Create Optimize SQL Sessions
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create a new session
- Select the SQL Details tab in the main window.
-
Click
.
To add a session
Click 
Note: You need to create a new connection for each new SQL Optimizer session.
Open Optimizer SQL Sessions
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To open a session
- Select the SQL Details tab in the main window.
-
Click
.
-
Select a Optimize session to open..