![]() See also Resolved Issues and Enhancements. This release includes an enhancement to the SQL parsing process which significantly reduces the time required to identify certain invalid SQL statements. Improved performance when identifying invalid SQL. ![]() SQL Optimizer for Oracle 9.3.1 is a minor release and includes resolved issues and the following enhancement. SQL Optimizer for Oracle 9.3.2 is a patch release and includes resolved issues and the following enhancement: SQL Optimizer for Oracle now displays data to 3 decimal places for run time statistics. Statistics are now shown with greater precision.In Optimize SQL module, you can now select "Ignore the cached execution plan" or "Reuse the cached execution plan" in the Test Run settings window to test run different bind values. New options to test run different bind values: "Ignore the cached execution plan" and "Reuse the cached execution plan".Click the Show Script button before the script is deployed. From the Plan Control Deploy page, you can now review the deployment script. ![]() New baseline deployment scripts for user review.SQL Optimizer for Oracle 9.3.3 is a patch release and includes resolved issues and the following enhancements: New Features SQL Optimizer for Oracle 9.3.3 It provides index recommendations for multiple SQL statements or a SQL workload, simulates index impact analysis, and generates SQL execution plan alternatives. SQL Optimizer also provides a complete index optimization and plan change analysis solution. Once SQL Optimizer identifies problematic SQL statements, it optimizes the SQL and provides replacement code that includes the optimized statement. SQL Optimizer analyzes, rewrites, and evaluates SQL statements located within database objects, files, or collections of SQL statements from Oracle's System Global Area (SGA). SQL Optimizer for Oracle automates the SQL optimization process and maximizes the performance of your SQL statements. ![]() Release Notes SQL Optimizer for Oracle 9.3.3
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |