A: Aside from privileges to connect, of course, some of the Schema Browser features might require access to the Data Dictionary views. Within Toad, we try to use USER_ and/or ALL_ where possible, but ...
For some time now Toad’s SQL Editor has offered several very basic SQL code refactoring capabilities. But to be honest those refactoring features did not see extensive use or adoption as they were so ...
In Version 12.1 Toad for Oracle added source control integration for Git, a popular distributed version control provider. Git is free software, distributed under the GNU general public license. Toad i...
A junior developer came to me recently and asked me a SQL transformation question. He gave me an example of a SQL statement similar to this one: select * from TableA A where A.KeyCol/10 = 12345 The p...
An Oracle explain plan is very much like a Google map of directions to drive from point-A to point-B (in the old days, before the web, we used to go to a local AAA to get a “Trip Tik” map). However a ...
Scan SQL helps you identify problematic SQL statements in your database environment by automatically extracting statements embedded in database objects, stored in application source code and binary fi...
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...
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...
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...
When writing a SQL statement, it is easy to be satisfied when you have figured out how to get the correct results. This is especially true when you are writing a complicated SQL statement. But in orde...
This tip covers executing SQL statements that require you to enter a parameter before the SQL statements are executed. A SQL statement with a variable which is provided at run time poses an extra chal...
This tip covers testing the SQL alternatives in a development environment when it is not possible to do extensive testing in the production environment. When optimizing a SQL statement, you need to t...
