This SQL Optimizer for SAP ASE video discusses the SQL repository which stores the SQL that you’ve identified as critical to the performance of your database.
Related Articles
SQL SERVER Management Studio – Exception of type...
I was trying to help my client in generating a report large data set. After spending some time and understanding the schema, I could provide them the query to get the results. Now, he wanted to save t...
Toad for Oracle – What does the execution time in the sql editor...
What I'm trying to pin down is how accurate the execution time displayed in TOAD is. For some complex queries, the time displayed may be 1 second. If I trace the query using TKPROF it reports about 4 ...
How Enterprise Manager Detects the Version of Oracle Databases
You know that patch numbering has been changed since November 2015, and the new format replaces the numeric 5th digit of the bundle version with a release date in the form “YYMMDD”. Let’s say you appl...
