Release Notes > Cursor Query Plan Conversion
When a SQL statement is used inside a cursor declaration, the query plan that Adaptive Server generates is different than the query plan that Adaptive Server generates for the same SQL statement used without a cursor declaration.
Release Notes > SQL Scanner Window
The SQL Scanner window has 3 panes, a status bar and a toolbar. ... This column is blank until the Job is scanned. ... After the Job is scanned it displays the number of SQL statements found. ... Displays the number of valid SQL statements found in the Job.
Installation Guide > Start and Stop the Performance Monitor
The Performance Monitor provides three ways to monitor the database performance: immediate monitoring, scheduled monitoring, and manual refresh. ... The settings on the General tab in Preferences window determine whether the monitoring process begins immediately or at a scheduled time.
Installation Guide > Retrieval Criteria (QP Metrics)
When using the QP Metrics, the Retrieval Criteria page of the Add/Modify Inspector wizard consists of the following settings: ... Target Database ... Specific the database from which to retrieve the SQL statements and the run time statistics.
Installation Guide > Drop Temporary Tables
After the User-Defined temporary tables are created, you can drop them. ... Click . ... Select the Temp Table List tab. ... If you want to remove all temp tables, click Drop All Table. ... Related Topics
User Guide > Example of Temporary Tables in SQL Scanner
In the above example, when the SQL Scanner finds the first INSERT statement, it executes the CREATE TABLE statement, so that the temporary table #temp1 is created. ... The query plan for the INSERT statement is obtained and the statement is classified as to how likely it is to be causing a performance problem.
User Guide > SQL Termination (Percentage Delay)
The SQL Termination tab is used to determine the percentage delay calculation and then adds the additional time to the termination time. ... It is used to account for the time it takes the SQL statement to travel from the PC to the database server over the network.
User Guide > Schedule Time (QP Metrics)
The Schedule Time page of the Add/Modify Inspector wizard consists of the following settings: ... Start inspecting now ... Specify to start the inspection as soon as you click the Inspect button.
Installation Guide > SQL History Overview
Throughout the program, SQL statements are saved in the SQL History so that you can use them again. ... They are stored in a file so that they are always available to work with again. ... Related Topics
User Guide > User Experience Feedback
SQL Optimizer collects data about the use of different features within Quest SQL Optimizer for SAP ASE. ... The data collected is anonymous and aggregated. ... The data is briefly stored on the Amazon Cloud before being moved to servers in the US maintained by PreEmptive Solutions.
User Guide > Right Pane for SQL Analyzed Folder
In the Index Impact Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information displays in the right pane. ... Cost Summary button ... Displays all the SQL statements and shows the Estimated I/O Cost with and without the proposed indexes.
Release Notes > Right Pane for Information
This SQL Statement Information section provides information about currently executing SQL statements and recently executed SQL statement. ... Locks Information ... Returns a list of all locks that are being held, and those that have been requested, by any process, for every object.
User Guide > Bracket Pairing
Simple mistakes are often made during SQL construction because of uneven left and right brackets. ... With bracket pairing, the corresponding open bracket is matched with the closing bracket as you type the closing bracket.
Release Notes > Enter Original SQL Statement
The SQL statement that you want to optimize is referred to as the original SQL statement. ... To optimize a SQL statement ... Click . ... Enter the SQL statement by typing it in, opening an existing file, or pasting it.
User Guide > New Analysis Wizard: Analyzer Page
The Analyzer tab is used to name the analysis and to select the folder where the SQL statements that you want to analyze are stored. ... Creating a new Analyzer and select SQL to be analyzed ... Select this option to create a new analysis using a different set of SQL statements.
Installation Guide > New Analysis Wizard: Analyzer Page
The Analyzer page is used to name the analysis and to select the folder where the Analyzer information will be stored. ... Item ... Enter the name for the analysis. ... Enter the description for the analysis.
User Guide > Migration Analyzer Window
The Migration Analyzer window displays performance analysis information about the SQL statements and query plans analyzed between two Adaptive Server versions. ... For each performance analysis selected from the tree view in the left pane, overall performance change metrics and details on query plan changes are provided in the right pane.
Release Notes > Editor
The Editor tab of the Preferences window allows you to define the editable panes control and layout. ... Specify whether to use the tab character (ASCII 9) instead of spaces. ... Smart tab (Default = checked)
Installation Guide > Scan Inspected SQL
The SQL statements that you have filtered in the Statistic pane of the SQL Inspector window can be scanned in the SQL Scanner to classify the SQL statements to help identify which SQL statements are likely to be causing performance problems.
Release Notes > New Analysis Wizard: Destination Configuration Page
The Destination Configuration page is used to change the database parameters on the migration database and only available after you have entered your migrating database connection information on the Migration tab.
User Guide > SQL Information Pane
It provides a variety of information about the SQL statement like the query plan, abstract plan, trace on and run time information. ... The specific information is dependent upon the function of the module.
Release Notes > View Migration Analysis Details
The Migration Analysis Details window displays information about the retrieve of the query plan for each SQL statement. ... The Migration Analysis Details window displays after the batch run process is completed unless the Show details on next batch run checkbox in the Migration Analysis Details window is unchecked.
User Guide > SQL Classification
Based on the query plan, a SQL statement is classified according to the characteristics of the query plan. ... If the query plan is not retrieved successfully, then these SQL statements are classified as Invalid SQL.
Release Notes > Supported Monitoring Tables
The Performance Monitor supports both dynamic performance information and static information from the following Adaptive Server monitoring tables: ... Provides information regarding the overall state of the Adaptive Server.
Installation Guide > New Analysis Wizard: Abstract Plan
In the New Analysis wizard, the Abstract Plan page is used to include the abstract plan with SQL statements. ... Review the following for additional information: ... Dump abstract plan ... Specify whether to retrieve the abstract plan for the SQL statement for the before the configuration parameters are changed.
Neue Produktverknüpfung
- Self-Service-Tools
- Knowledge Base
- Benachrichtigungen und Warnmeldungen
- Produkt-Support
- Software-Downloads
- Technische Dokumentationen
- Benutzerforen
- Videoanleitungen
- RSS Feed
- Kontakt
- Technische Support
- Alle anzeigen