The 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 () 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.


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal