A full preview is in the works, but sometimes a new feature is so compelling you just want to start telling strangers on the street about it right away. Rather than make you wait till tomorrow to hear all about Apple’s new tablet device, here’s some juicy Toad gossip right now!

 

DESCribe

Perhaps one of the most productivity-enhancing features in Toad, the DESC (F4) command allows the user to get access...

In this post I'll show how to produce an exception report using the row count variable and if..condition automation activity.

Scripting repetitive tasks can ease your work load. Here's how to do it in TDA.

A simple, step by step guide for creating TOAD Report Manager reports and templates (TRD -TOAD Report Definition format).

Written by Finn Ellebaek Nielsen. A short introduction to Continuous Integration (CI) and a description of how to integrate testing Oracle code with QCTO in a CI environment.

Oracle Real Application Cluster (RAC) is a single database that is shared by multiple Oracle instances. It provides opportunities for improved database availability, performance and scalability. Oracle RAC lowers the TCO of a high-end database and IT assets, since a complex Oracle database can be set-up on low-cost, standard, modular parts. Oracle RAC has matured into a true enterprise, scalable solution, but the adoption curve and skill-set required to maintain RAC is relatively slow, as most organizations who have installed RAC only use it as a two-node cluster.

...

Using indexes can improve the performance of applications using the database. This is well known to many, many people. However, the application of too many indexes can have the reverse effect. There’s a balance that must be struck and you may find yourself needing to locate indexes that aren’t being used. If you’re already using the Quest SQL Optimizer for DB2 LUW, you can take advantage of the Index Usage Analyzer to help...