Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

extend DBMS_XPLAN.DISPLAY% functions by an ORDER column

berxNov 27 2021 — edited Nov 27 2021

In an execution plan, the order of the lines is well defined, but not always easy to spot, especially for the untrained eye.
This idea is based on some discussions, and a good example can be seen in https://asktom.oracle.com/pls/apex/asktom.search?tag=confuse-at-the-order-of-execution-plan-table.
The xplan.display_cursor script can easily add a Order column, so this can not be a technical problem to implement. In best case, an additional format option +order can be provided.

Comments

Post Details

Added on Nov 27 2021
0 comments
69 views