Toad for Oracle’s SQL Optimizer for Oracle® automates the SQL optimization process and maximizes the performance of your SQL statements. SQL Optimizer for Oracle® analyzes, rewrites, and evaluates SQL statements located within database objects, files, or collections of SQL statements from Oracle’s System Global Area (SGA). Once SQL Optimizer identifies problematic SQL statements, it optimizes the SQL and provides replacement code that includes the optimized statement.
SQL Optimizer also provides a complete index optimization and plan change analysis solution. It provides index recommendations for multiple SQL statements or a SQL workload, simulates index impact analysis, and generates SQL execution plan alternatives.
A webcast series for Toad customers
We’re excited to announce that we’ve developed a new webcast series “Ask Toad” directed toward existing Toad for Oracle users within your organization. These 30-minute live sessions, typically scheduled for the first and third Tuesdays of each month, will quickly review a valuable capability of Toad and will include time for questions. Our goal is to help you get the most out of your Toad investment and Q&A is important to that process.
We hope these sessions become a twice-monthly scheduled visit for you, with a chance to ask questions of one of Quest’s Toad consultants. Please join us for our January 29 session:
“ASK TOAD: How can you simplify and automate SQL optimization for developers in Toad for Oracle?”
Date: Tuesday, January 29, 2019
Time: 12 P.M. CST
Duration: 30 minutes
In this session, Toad consultant Russell Tuttle will:
- Discuss the reasons for using SQL Optimizer
- Demonstrate Toad’s SQL Optimizer
- Discuss SQL optimization steps and results
- Discuss scanning existing code for performance problems
- Discuss capturing running SQL and identifying issues
- Take your questions