Manage Outlines
Manage Outlines
Outline Management displays stored outlines deployed using SQL Rewrite mode in Optimize SQL. To manage outlines Select the Manage Plans tab in the main window. Tip: Select the Show Manage Plans che...
Best Practices
Best Practices
You can use Best Practices to analyze your SQL statement and database to recommend common techniques for improving database performance. Since the recommendations can also affect performance of other ...
Generate Indexes in Optimize SQL
Generate Indexes in Optimize SQL
SQL Optimizer identifies columns to use as index alternatives for a SQL statement after it analyzes SQL syntax, relationships between tables, and selectivity of data. SQL Optimizer then combines ident...
Deploy Outlines
Deploy Outlines
The Deploy Outline function in Optimize SQL improves SQL statement performance without changing your original source code. Using Optimize SQL, you can generate SQL statements that are semantically equ...
Batch Optimize SQL
Batch Optimize SQL
To batch optimize SQL Select the Batch Optimize tab in the main window. Click Add Code to Optimize in the Batch Job List pane and select All Types. The Add Batch Optimize Jobs window displays. ...
Analyze Impact
Analyze Impact
Use Analyze Impact to evaluate the impact that a change can have on a group of SQL statements or a SQL workload. The types of changes Analyze Impact will allow you to evaluate include: the addition of...
Toad for Oracle – DB Health Check
Toad for Oracle – DB Health Check
This video covers new Production, Configuration and Virtualized databases as well as explanation windows & report....
Toad for SQL Server – Database Development
Toad for SQL Server – Database Development
Toad for SQL Server is a productivity toolset for database administration and development. You can download a free 30-day Trial of Toad for SQL Server...
Toad for Oracle – Master Detail Browser
Toad for Oracle – Master Detail Browser
The Master Detail Browser lets you view/edit objects linked together with foreign keys or user-defined relationships....
Toad for Oracle – Monitor SQL Executed on Databases (SQL Tracker)
Toad for Oracle – Monitor SQL Executed on Databases (SQL Tracker)
Quest SQL Tracker monitors SQL statements issued by Windows applications and services that access Oracle....
Toad for Oracle – Auto Debugging PL/SQL Code
Toad for Oracle – Auto Debugging PL/SQL Code
Learn how to use Toad for Oracle's auto debugger feature to automatically debug code in the Editor with DBMS_OUTPUT statements....
Toad for Oracle – Log Switch Frequency Map
Toad for Oracle – Log Switch Frequency Map
The Log Switch Frequency screen shows when your database performs a log switch. Many DBA's aim to size their redo logs so that there are few log switches per hour. Frequent log switches can dramatical...
- Go to the previous page
- 1
- …
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- …
- 149
- Go to the next page