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 Explain Plan Advanced Options
I have used the Toad explain plan advanced options to show SQL bind variable content for a while. I want to show you how to get this advanced information when doing SQL tuning with Toad. When tuning S...
Oracle Wait Events – direct path write
A direct path write I/O operation is just the opposite of the direct path read operation, and it writes buffers from a session's PGA to the datafiles. The direct path write operation allows a session ...
Automating Automation in Toad Data Point
Recently I was talking to a group of Data Analysts about using Toad Data Point to access their multiple data sources and make sense of the data. As I was taking them through the process of building qu...
