User Guide > Batch Termination
The Batch Termination page of the Batch Run Criteria window is used to determine if and when to terminate the Batch Run. ... It enables you to find alternative SQL statements that give you good performance improvement without having to execute every SQL alternative.
Installation Guide > Modify Data
Select the table or view you want to modify from the left pane of the Database Explorer window. ... Select the Data tab from the bottom of the right pane ... Use the button bar at the bottom of the pane to select an editing option.
User Guide > Group Manager Window
A scanner Group is used to store Jobs (files, database objects, abstract plan groups, Inspectors, or Collectors from the SQL Collector for Monitor Server). ... The Group Manager window is used to create, open, delete, and rename these Groups.
Release Notes > Add SQL Wizard: General Page
The General page of the Add SQL wizard is used to name the SQL statement and to select the folder where you want the SQL statement saved. ... Item ... Enter the name for the SQL to be saved in the SQL Repository.
User Guide > Chart Drill Down
you can click a data point in a higher-level chart to drill down to a chart for that specific statistic.
Installation Guide > Rename an Index Usage Analysis
You can rename an analysis in the Index Usage Analyzer window in two ways. ... Right-click the Analysis you want to modify from the left pane and select Rename. ... A highlighted field is placed around the SQL name in the tree to indicate that you can edit the name.
User Guide > Database Explorer Tutorial
The Database Explorer displays detailed information about database objects including columns, indexes, keys, statistics, DDL, procedure text, and data from the tables. ... Browse Database Objects
Release Notes > Optimization Details Window
The Optimization Details window is optional and can be displayed after optimization. ... This window displays the following: ... Number of alternative query plans produced. ... How many SQL statements were eliminated because they had identical query plans.
Installation Guide > Add SQL Wizard: SQL Information Page
The SQL Information page of the Add SQL wizard is where to enter the SQL text and view various information about the SQL statement, such as the query and abstract plans. ... Left pane ... Enter the SQL text.
Release Notes > Plan Detail
The Plan Detail window provides detailed information on the selected branch of the query plan. ... This window is opened in two different ways depending on which display view you have selected for the query plan.
User Guide > Regular Expression
Regular expressions are characters that customize a text search string. ... They formulate a more complex search. ... You must select the Regular expression checkbox to use these advanced search features.
Installation Guide > Silent Install of SQL Optimizer
/n = no UI ... /i = install ... To install it in a directory different from the default product directory, use this command
User Guide > Lock and Unlock Chart
When the Performance Monitor is capturing statistics, the display is updated every time the statistics are gathered. ... This means that you could be reviewing some statistics and they would change while you are viewing them.
Release Notes > SQL Inspector Overview
The SQL Inspector identifies SQL statements with performance problems by extracting SQL statements and SQL performance statistics from the QP Metrics (Adaptive Server 15 or later). ... The SQL Inspector graphically displays and compares SQL activity statistics to diagnose performance bottlenecks.
User Guide > Quick Find
The Quick Find search function searches for the text that is highlighted and moves the line containing the search string to the top of the text pane. ... To search with Quick Find ... With text highlighted in the active window, select Search | Quick Find [Ctrl + Alt + F]
Installation Guide > Why Save the Abstract Plan?
Saving the abstract plan for a SQL statement preserves how the SQL statement is executed. ... Therefore, when changes occur in the database environment, the query plan used to execute the SQL statement remains constant.
User Guide > Index Advisor Window
Used to enter the SQL statement you wish to analyze for index recommendations. ... Database Objects tab ... Displays information about the tables used in the SQL statement. ... Displays a list of the individual index candidates proposed by the Index Advisor.
User Guide > Plan
Table Scan warning threshold (records) ... Enter a threshold warning value for table scans between 1 and 2147483647. ... If the estimated rows for a table scan is larger than this value, the TableScan icon turns red.
Installation Guide > Abstract Plan Compatibility with Original SQL
Adaptive Server generates an abstract plan based on the SQL syntax itself. ... If a SQL statement is transformed to another syntax that the Adaptive Server optimizer cannot transform internally, then the abstract plans are not compatible.
Release Notes > Determine Best Performing Index Alternative
After you generated Index candidates or created Index Sets for your original SQL statement in the Index Advisor window, you need to determine which indexes give you the best performance. ... The Batch Run function is used to retrieve the run time of the original SQL statement for different index candidates or set.
Installation Guide > Forces (Pre-ASE 15)
The Forces page on the Optimization for Pre-ASE 15 tab of the Preferences window allows you to decide if you would like to have the Adaptive Server forces applied to alternative SQL statements. ... By adding an Adaptive Server force, you can force the Adaptive Server’s internal optimizer to choose a particular query plan.
User Guide > Filter the Run Time Results
The current filter displays in the bottom left corner of the Time or Statistics pane. ... To filter the Index Sets ... Click the downward pointing arrow to the right of a column heading. ... Select one of the following:
Installation Guide > Bookmarks
Bookmarks can be set to quickly return to a place in your code. ... To set a bookmark, right-click, select Toggle Bookmark or select Set | Toggle Bookmark and then pick a bookmark number between 0 and 9.
User Guide > New Analysis Wizard: Select SQL Page
The Select SQL page is used to select the SQL statements whose query plans you want to analyze when various database parameters are changed. ... Select SQL to check for performance changes: ... The SQL statements used in an analysis can be taken from the SQL Repository and the SQL Scanner.
新产品关联性