Quest® SQL Optimizer for SAP ASE offers a fully automated approach to maximizing SQL performance. It eliminates the manual, time-intensive process of ensuring that SQL code is performing as fast as possible.
Related Articles
Oracle Database 12c Deferred Global Index
Introduction Before Oracle 12.1.0.1, whenever a table partition was dropped all the global indexes that were created on that table became UNUSABLE unless we specified the clause UPDATE INDEXES in the ...
SQL Optimizer for SAP ASE SQL Worksheet
In this video we demonstrate how to use SQL Optimizer for SAP ASE's SQL Worksheet to enter and execute multiple SQL statements and T-SQL scripts....
Snorkelling in the Oracle Listener Logs.
(Snorkelling is not quite as in depth as a “deep dive”!) Attempting to parse a listener.log will probably bend your brain, but I needed to do it recently to determine which unique servers and/or desk...
