Using the loop dataset in Automation in Toad Data Point 3.3 and later
Using the loop dataset in Automation in Toad Data Point 3.3 and later
...
Automating Excel macro reports with Toad Data Point
Automating Excel macro reports with Toad Data Point
...
Using the while loop in Automation in Toad Data Point
Using the while loop in Automation in Toad Data Point
...
Using variables in Automation in Toad Data Point
Using variables in Automation in Toad Data Point
...
Toad Data Point Automation Series: Blog #8 – Importing Data
Toad Data Point Automation Series: Blog #8 – Importing Data
Upon occasion you may find a need to import data into a database. That database might be your own sandbox or you can use the Toad Sample database or Local Storage. I am going to show you three differe...
Toad for Oracle – How to tell what columns would be good for indexes
Toad for Oracle – How to tell what columns would be good for indexes
Ever wonder how to tell what columns would be good for indexes? Once the index is created, ever wonder why you never see it in SQL explain plans you would expect to see it in??? There are 2 useful st...
How the Batch Optimizer Works
How the Batch Optimizer Works
This tip gives an overview on the functionality in the Batch Optimizer. Batch Optimizer Process The Batch Optimizer combines into one simple process the finding of SQL statements in your applicatio...
Why Run Times Vary
Why Run Times Vary
This tip covers why the run time of a SQL statement may vary from one execution to the next. When you execute a SQL statement several times in Quest SQL Optimizer, you may notice that the run time wi...