Plan Control SQL tuning was our main target for SQL Optimizer for Oracle V8 development over the past few months so the time available for the rewrite engine was limited. I planned to add sub-query factoring and sub-query de-factoring rules in this release but the complexity of those two rules is huge and there wasn’t time enough to complete them. So I selected two simpler rules from our rules library and incorporated them into SQL Optimizer Version 8. In terms of coding time, these two rules took just a few days to implement but the result is promising for some SQL statements that were not easy to improve by manual SQL tuning.  For Part 1 of this blog entry I will discuss the first rule - Part 2 will discuss the second.

Have you often wondered, as you’re using Toad, and frequently running your schema compares, executing multiple scripts, generating your reports or even saving table data to files – is there a quicker way to do this?

 

I’m sure you have, which is why Toad’s task automation feature can save you hours, enabling you accomplish your routine tasks faster leaving you to concentrate on other things.

 

First introduced three years ago as Action Palette in Toad version 9.1, the current Automation Designer in Toad 10.6 has come a long way in terms of what can be automated and how it integrates with the rest of Toad.

A new Toad version is now available and before you try it out, I thought I’d give you a quick preview so you’ll be up to speed on what to look for.

 

Toad 10.0 (October 2009) introduced the beginning of a new generation of Toad releases which offer significant improvements in productivity to developers, DBAs and analysts.

In this posting I will go over debugging steps to find out why a scheduled Toad for Data Anaylysts Script does not appear to be running.

Where a database column and its content is larger than the size you wish to show in a report, it is easy to just substring the column value to fit your report column size. However, this often does not look that good in user facing reports.

In the good old days most DBA’s could walk into their computing center and point to their database server and its disks. Furthermore, many DBA’s could also point to specific disks and state which database objects they housed. In fact database object placement and separation was a key tuning consideration back in the day. Oh my how times have changed.