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.
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