Wednesday, September 5, 2018

SQL Developer: Renaming Columns in the cloud or not


Hey did you miss this in the latest drop of SQL Developer?  You can now rename the columns in the AUTOTRACE output! Way cool!! (Oh and Explain Plan too.)

Since I do a lot of screen shots this is great.  A lot of the columns in AUTOTRACE start with the work LAST, so when shrinking columns to make the screen shot a nice size the names are less than useful.  For example:







Notice the thee columns with just “LAST…” in them, um, which is which? Well now I can right click on the column heading and rename it!  YES!  This is very nice.









The SQL Developer team keeps hitting home runs.  Go Team!!





Jeff Smith (yes, thatjeffsmith)  asked me to add what I'd suggest you should rename columns in AUTOTRACE to.  So here are some of them that I think are important to be viewing in your plans that should be renamed.   Some are fine they way they are like OPTIONS, ID and COST.  Even these could be renamed using initcap to just make it a bit easier to read.



Current Name
Suggested Name
CARDINALITY
E-Rows
DISTRIBUTION
PQ Dist
LAST_CR_BUFFER_GETS
CR_Buffers or CR_LIOs
LAST_CU_BUFFER_GETS
CU_Buffers or CU_LIOs
LAST_DISK_READS
PIOs
LAST_ELAPSED_TIME
A-Time
LAST_MEMORY_USED
Used-Mem or Memory
LAST_OUTPUT_ROWS
A-Rows
LAST_STARTS
Starts
OBJECT_NAME
Name
PARENT_ID
PID
QBLOCK_NAME
QB_Name


No comments:

Post a Comment