Page History

Wiki MarkupThe preferences on this page allow you to change the default presentation of count information and sub-query names in Visual SQL Tuning diagrams.

\\ Using the SQL Optimization perspective, select *Preferences * * > * * Tuning * * Job * * Editor * * > * * VST Diagrams{*}. \\ • *Show* *count* *information{*}: If enabled, shows the ratios and count information when the VST diagram is generated. If not enabled, you must click the *Ratios/Counts* icon \[ !worddav1ef2ba970e4e5e69385a67a914afbb31.png|height=16,width=16! \] on the VST diagram to view ratio and count information. \\ • *Hide* *sub-query* *names* *when* *expanded{*}: If enabled, shows the sub-query name when the VST diagram is generated. If not enabled, you must right-click anywhere in the VST and from the menu that appears, choose *Show* *Query* *Names{*}. \\.

• Show count information. If enabled, shows the ratios and count information when the VST diagram is generated. If not enabled, you must click the Ratios/Counts icon (Image Added) on the VST diagram to view ratio and count information.
• Hide sub-query names when expanded. If enabled, shows the sub-query name when the VST diagram is generated. If not enabled, you must right-click anywhere in the VST and from the menu that appears, choose Show Query Names.