View Schema Information
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view schema information
- Select the SQL Details tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Click
beside the Summary list and select a table for additional information.
View Bind Variables
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To view bind variables
- Select the SQL Details tab in the main window.
-
Select the Bind Variables tab in the Optimize SQL window.
The parameters for the bind variable defined for your SQL statement display. Set Bind Variables
Note: Information is only displayed in this tab if you used variables for optimization.
Show or Hide Table Attributes
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To show or hide a table attribute
- Select the SQL Details tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Right-click the header row in the Summary Details pane and select Column Chooser.
-
Add or remove table attributes by dragging the column names to and from the Customization dialog.
Show or Hide Column Attributes
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To show or hide a column attribute
- Select the SQL Details tab in the main window.
-
Select the Schema Information tab in the Optimize SQL window.
-
Click
-
Right-click the header row of the Column Attributes pane and select Column Chooser.
-
Add or remove column attributes by dragging the column names to and from the Customization dialog.