No database can process all queries expediently, but we can strive to make sure our databases process SQL as efficiently as possible. That means applying SQL performance tuning and optimization to our...
Based on my experience, I believe that Quest® Toad® for Oracle is the best SQL Trace analysis tool for SQL performance tuning. This blog, and related articles around using Toad for Oracle Expert Editi...
![Quest® Database Training Days: The biggest names in tech [Free Webinars]](https://s38063.pcdn.co/wp-content/uploads/2025/09/fi-Blog-DTD-Janis-GriffinNeedforSpeedFEATURE-1-300x200-1.jpg.optimal.jpg)
We're bringing the biggest names in tech, right to you. Join us for this free, interactive learning experience. We get it. Due to Covid-19, some of the very best technology, live, in-person events h...
Did you know that you can predict the future performance for individual SQL statements and use these predictions to mitigate future performance issues using the Toad® for Oracle Spotlight® on Oracle f...
[Blog and webcast.] The clock is ticking. You’re way overdue to update your Windows operating system, but you can’t because you’re still using Brio (Hyperion IR) —which is no longer being supported. M...
I’m thrilled to announce that we’ll be hosting a pre-con at SQL Grillen this June in Lingen, Germany titled “Designing Azure Infrastructure for Data Platform Projects”. The abstract for the session is...
How are the sqls performing today? Often, I face this question. First I will try to parse the question into simple terms. The sqls – what sqls? On any given day, the top 10 resource intensive sqls. ...
Temporal data support, introduced with Db2 10 for z/OS, is one of the more interesting SQL-related Db2 enhancements delivered in recent releases of the DBMS. Temporal data support comes in two flavors...
In this, the fourth of a set of four entries covering SQL enhancements introduced with Db2 12 for z/OS, I will describe new trigger capabilities delivered by way of what are called "advanced triggers"...
A new feature for Oracle Data Mining (ODM) (part of SQL Developer 4.2) is the ability to schedule an ODM workflow to run a defined time or frequency. This blog post will bring you through the steps ne...
Greetings, and welcome to the third in a series of entries covering my favorite Db2 12 for z/OS SQL enhancements. The first two posts in the series described piece-wise DELETE and result set paginatio...
