In this SQL Optimizer for SAP ASE video, we demonstrate how the Index Impact Analyzer shows the impact of adding or removing an index to a SQL statement.
Related Articles
Toad for Oracle – How can I pass parameters to an external application?
This example shows how to load a script into SQL*Plus for the current session and execute it: Go into PM Options → Associations Remove SQL as an extension for SQL Editor (or anywhere else it may ...
Oracle Tuning the Database for Optimal Physical I/O
Once the application and memory areas have been tuned, the next performance bottleneck can be the disk subsystem. A number of performance indicators can suggest a need to improve Oracle disk I/O. A ma...
One-Step Schema Copy to the Cloud Using Data Pump!
In this blog, I'm going to copy the SCOTT schema from a private database, which is behind a firewall, to an Oracle Cloud database. I should qualify "One step" as "One step once everything is set up",...
