The Code Insight feature rewrite for version 9.6 is perhaps the most dramatic change as it will affect every Toad user who writes SQL or PL/SQL.
In a nutshell, for the 9.6 release, users can now start at the schema level, and use the ‘Dot Lookup’ feature to see all tables, views, synonyms, snapshots, PL/SQL objects etc. You can then drill down to the column level where possible.
Here’s what it looks like now:
You can configure the delay time for Toad to query the object details in the Options Dialog.
In previous versions of Toad, users could only use the ‘Dot Lookup’ Code Insight feature to pull up column names. Toad continues to be able to resolve aliased objects in the editor.
Using the options control button in the ‘Dot Lookup’ window, you can configure which object types to query. In large databases where the number of Public Synonyms can be quite high, this can have a negative performance impact. For this reason, this object type is DISABLED.
Turning this on can increase the amount of time and memory required for this feature.
If you are working on a database that does not have thousands of Public Synonyms, then you will want to enable this feature. Now you can do cool things like:
Toad supports object aliasing for its ‘Dot Lookup’ feature.
An Additional Performance Tip
Make sure that ‘Cache Code Insight Results’ is enabled. For each user you do a lookup feature for, those entities will be cached into memory. With this disabled, Toad will re-query the data dictionary every time you do a ‘Dot Lookup’ call.
Toad will let you know if one of these options is causing you problems via the Toad Advisor feature (available under the ‘Help’ menu.)
Is Toad running slowly for you? Use the Toad Advisor to discover configuration issues.