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.