User Guide > Database Explorer Functions
Below is a list of functions available in the Database Explorer window. ... Related Topics ... Database Explorer Overview
User Guide > Configuration Analyzer
User Guide > Result Set (General Tab)
The Result Set page on the General tab of the Preferences window allows you to set preferences for editing data. ... Edit data ... Specify to automatically commit the data when editing the data in the data girds.
User Guide > Format a SQL statement
The SQL Formatter checks the syntax of the SQL statement. ... The SQL statement is formatted only if the syntax is correct. ... The right pane [Formatted SQL] of the SQL Formatter window shows the formatted SQL statement.
Installation Guide > User Logon Privileges
Adaptive Server has database privileges that either allow or restrict the access and authority of each user. ... When you logon to SQL Optimizer, it checks to see if the logon satisfies the privileges.
Release Notes > Simple SQL
SQL statements are classified as Simple SQL if they meet the following requirement and do not meet any requirement for being a Problematic SQL statement or a Complex SQL statement: ... Number of table operations less than (Default = 2)
User Guide > Connect to the Database
When SQL Optimizer starts, a User Logon dialog field displays for you to connect to the Adaptive Server database. ... The Server list contains the database servers taken from the SQL.INI file. ... After selecting and entering the connection information, click Connect.
Installation Guide > Synchronizing the data dictionary
Specific database information, such as tables, indexes, data volumes, and so on, from the data dictionary is used during the optimization process, SQL analysis, and other functions throughout program.
Installation Guide > Data Directory Setting
The SQL Inspector data directory is where the data files are created while executing the Inspect function. ... The data directory path is set in the Preferences window. ... Click . ... Select the Directory Setup tab.
Installation Guide > Save Optimized SQL
Unlike a report, this file is used to reload the SQL back to the SQL Optimizer window using the Open Optimized SQL function. ... To save the original SQL and the SQL alternatives ... Select SQL | Save Optimized SQL.
Release Notes > SQL Collector for Monitor Server Tutorial
The SQL Collector for Monitor Serverallows you to capture from the ASE Monitor Server any currently executing SQL statements according to your user-defined criteria. ... Each SQL statement captured is categorized according to suspected levels of performance problem.
Installation Guide > Migration Analyzer Functions
Below is a list of available functions within the Migration Analyzer window. ... Description
Installation Guide > Modify a Job
The Modify Job dialog field allows you to do the following: ... Modify Job description ... Change the file type ... Eliminate duplicate SQL while scanning. ... When modifications are made to a Job, it must be rescanned.
User Guide > Abstract Plan Manager
Release Notes > Retrieve Run Time for a Group of SQL
The Batch Run function is used to retrieve the run time of a group of optimized SQL statements. ... To start the Batch Run ... Select your batch run criteria and click OK. ... The Batch Run window displays the run time criteria and the run time of the SQL statements as it is retrieved.
Release Notes > Mark and Unmark All Jobs
The black checkmark is used to indicate that the job is marked; any appended symbol is removed to indicate that the job is unmarked in the SQL Scanner window. ... To mark or unmark all Jobs ... Select Group | Mark All [Ctrl + M] or select Group | Unmark All [Ctrl + U].
Installation Guide > Abstract Plan Group
Abstract plans are saved to an abstract plan group. ... The group has the following elements associated with it: ... When you save an abstract plan, you specify the database, group and user. ... This means that you can have a different abstract plan for different users.
Release Notes > View Group Summary
The Group summary report provides a statistical list and charts of all the Jobs and SQL statements scanned within the Group. ... To view the report ... With the SQL Scanner window as the active window, select Report | Group Summary.
User Guide > Index Usage Analyzer Functions
Below is a list of available functions within the Index Usage Analyzer window. ... Menu ... Function
User Guide > Optimize Original SQL Statement
To optimize a SQL statement ... In the SQL Optimizer window, enter the SQL statement in the SQL Editor pane of the SQL Optimizer. ... Click . ... The time it takes to optimize is dependent on the complexity of the original SQL statement and the quota values set in the Preferences window.
User Guide > Advise Index Alternatives
Click . ... Enter the original SQL statement for which you want to analyze for new indexes that could be created to change SQL performance. ... You can also copy the SQL statement directly from another window using the Send to Index Advisor function.
Release Notes > Right Pane for SQL Statements
When a SQL statement is selected in the left pane, the following information displays in the right pane. ... Properties button ... Displays general information about the analysis, information on the connection used to retrieve the query plans and the database settings at the time of the analysis.
Release Notes > Rename an Index Impact Analyzer
Select the Analysis you want to modify from the left pane. ... Right-click and select Rename. ... A highlighted field is placed around the SQL name in the tree to indicate that you can edit the name.
新产品关联性