Minor feature request. I'm on a 1280 X 1024 resolution and due to the browser taking up about 1/3 of the real estate inside PSD, the horizontal width of the Explain Plan window is limited as to how much data can be displayed.
So using Preferences for Plan window, I narrowed it down to the most important columns for me (description, cost, cardinality, object name, partition start/stop, access predicates and cpu/io cost). Being able to drag and drop them into the order I desire is nice.
However, I'm unable to change the names of the column headers in the explain plan grid. For example, "Partition start" and "Partition stop" make the columns much wider than they need to be. I compress the columns, but then the headers say "P..." and "P...". I'd like to be able to modify the column headers (give aliases for the columns), so that I could rename "Cardinality" to "#", "Partition start" to "PS", "CPU cost" to "CPU", etc.
This way I'll be able to fit and immediately absorb more info about the plan, less fiddling with column resizing.
Also, whenever I do adjust the width of one of the Explain Plan window column headings, the pane immediately jumps to the far left. This is a bit annoying when fine tuning the Plan window's display.
Thanks.
So using Preferences for Plan window, I narrowed it down to the most important columns for me (description, cost, cardinality, object name, partition start/stop, access predicates and cpu/io cost). Being able to drag and drop them into the order I desire is nice.
However, I'm unable to change the names of the column headers in the explain plan grid. For example, "Partition start" and "Partition stop" make the columns much wider than they need to be. I compress the columns, but then the headers say "P..." and "P...". I'd like to be able to modify the column headers (give aliases for the columns), so that I could rename "Cardinality" to "#", "Partition start" to "PS", "CPU cost" to "CPU", etc.
This way I'll be able to fit and immediately absorb more info about the plan, less fiddling with column resizing.
Also, whenever I do adjust the width of one of the Explain Plan window column headings, the pane immediately jumps to the far left. This is a bit annoying when fine tuning the Plan window's display.
Thanks.