Welcome to the SQL Optimizer for Sybase Community
Advanced Search - Help - Search Toad World
Welcome, Guest
Login Login / Register
Help
NEW? Get Plugged In

Enhancments for Quest SQL Optimizer 3.1 for Sybase

  • Vista - The Vista operating system is supported.
  • ASE 15.0.3 - Adaptive Server 15.0.3 is supported.
  • Online Help - The online help has been reformatted.

Enhancments for Quest SQL Optimizer 3.0 for Sybase

  • Program Name Change - The name of the program is now Quest SQL Optimizer for Sybase. Previously, it was called Quest Central for Sybase – SQL Tuning. This changes the corresponding items in the Windows registry and the location where the data files are stored.
  • Performance Monitor - A new module called the Performance Monitor was added which displays information from the Adaptive Server monitoring tables available in Adaptive Server 12.5.0.3 or later.
  • Combine Viewer Windows - The Viewer windows in the SQL Scanner, the SQL Inspector, and the SQL Collector were combined with the main screen for the module so that instead of having two windows in each of the modules, they now each have one window.
  • Toolbar Location - The toolbars for each module are now contained within the module window. Previously, they were located with the main toolbar at the top of the main window.
  • Consolidated SQL scanning algorithms - In previous versions, there were two SQL scanning algorithms. One SQL algorithm extracted embedded SQL statements such as in Transact-SQL. The other one extracted SQL statements within quotes and all on one command line within the programming code, typically used for Java, C, and Perl source code. In this version the two algorithms for scanning SQL have been combined into one algorithm, so now you no longer need to select which algorithm to use.
  • Read Only Configuration Parameters - In the Configuration Analyzer module, the Adaptive Server parameters that are read-only or calculated parameters are dimmed so that they cannot be changed and used for the analysis.
  • Configuration Parameter Descriptions - In the Add Analyzer window for the Configuration Analyzer and the Migration Analyzer, the description for each Adaptive Server parameter was rewritten.
  • Statistics for Procedures - When you are reviewing the statistics from the monitoring tables in the SQL Inspector for SQL statements that were executed in a stored procedure, you can view the statistics for each SQL statement or you can view the sum of the statistics for all SQL statements in one procedure.
  • Refresh View while Inspecting - In the SQL Inspector, you can start viewing the results before the inspecting process is completed with the Refresh button.
  • Displays sp_monitorconfig information - In the Configuration and Migration Analyzers, the information for the sp_monitorconfig command is displayed with the configuration parameter in the New Analysis wizard. Note that Adaptive Server only provides this information for some of the parameters.
  • SQL Information Pane - The current setting for "Set Statistics Subquerycache On" is included with the other database settings in the Information Page in the SQL Information Pane.
  • Abstract Plan Manager - In the Abstract Plan Manager when you have drilled all the way down to the Plan ID and clicked the SQL Text tab, you can now choose to display the SQL statement as formatted or using word wrap.
  • New SQL Classification Preference: With full table scan iterated by nested loop - The classification of a problematic SQL statement now includes a criteria for an query plan that is doing a full table scan inside a nested loop with the ability for you to set the number of pages in the table.
  • New SQL Scanner Preference: Skip end of line continuation character - This preference enables you to scan SQL statements that are on more than one physical line in the text and have a continuation character at the end of each physical line.
  • New Optimization Preference: Optimization Goal - fastfirstrow - This preference sets the optimization goal to retrieve the first record as quickly as possible.
  • New Optimization Preference: Optimization Criteria – advanced_aggregation - This preference sets the optimization criteria to use eager aggregation.
  • Online Help - The online help file was changed from a WinHelp (.HLP) format to a HTML (.CHM) format.
  • Tutorial available in Online Help - The Getting Started Help file was combined with the Online Help file. The Getting Started information is now under the Online Help topic "Tutorial."
  • Help for Abstract Plan Keywords - The context sensitive help for the each keyword in the Abstract Plan was rewritten.
  • Query Plan - The query plan can now be displayed graphically or in different text formats.
  • Query Plan Comparison - In the Analyzer modules and the SQL Comparer module when the query plans are displayed side-by-side, the differences between the plans are highlighted in green.
  • SQL Optimizer Community for Sybase - You can find out the latest information about Quest SQL Optimizer for Sybase and communicate with other users and the SQL Optimizer development team at our online community.
  • User-Defined SQL alternatives - In the SQL Optimizer module, you can now add your own SQL alternatives so that they can be compared to the original SQL and the SQL alternatives generated by the SQL Optimizer.
  • Home page - When you open the product a home page is displayed by default. This displays the What's New page and if you are connected to the Internet, this home page automatically launches the Inside the SQL Optimizer for Sybase community web page: http://sqloptimizersybase.inside.quest.com
  • Adaptive Server 15.0.1 and 15.0.2 support

    • Aggregated Functions - These new aggregated functions from Adaptive Server 15.0.2 are supported in the SQL parser and can be used throughout the modules in Quest SQL Optimizer: stddev, stddev_samp, stddev_pop, variance, var_samp, var_pop, stdev, stdevp, var, and varp.

    Functions - These new functions from Adaptive Server 15.0.1 and 15.0.2 are supported in the SQL parser and can be used throughout the modules in Quest SQL Optimizer: rand2, authmech, hashbytes, hash, index_name, asehostname, reserve_identity, xa_bqual, xa_gtrid, isdate, isnumeric, and partition_object_id.

    New Trigger Type - The INSTEAD OF TRIGGER type from Adaptive Server 15.0.2 is supported.

    SET optimization criteria statement parameters - The ON, OFF, and DEFAULT parameters are supported for SET optimization criteria statement. Note: the optimization criteria are shown on the Criteria page of the "Optimization for ASE 15" page in the preferences window.



© 2009 Quest Software, Inc  |  Legal Agreement  |  Privacy Policy  |  Terms of Use  |  Report a Problem with This Site
Powered By Jive Software