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
Oracle Coding Best Practices: Making a CASE for the CASE statement
This article will discuss the CASE statement. PL/SQL has had the CASE statement since Oracle9 I believe (an eternity for most of today’s coders). I will also illustrate a little-known fact: The CASE...
Toad Data Point v3.0 – Automation Enhancements
Watch as Toad Data Point expert, Debbie Peabody, demonstrates the automation enhancements in Toad Data Point version 3.0....
Bind Sensitive SQL May Also be Place Sensitive
I have heard a lot of people ask "Why my SQL performance is vary depending on where the SQL is executed ?", sometimes you may notice that the same SQL is performing good in one place, but not good in...
