Forum Stats

  • 3,816,776 Users
  • 2,259,232 Discussions
  • 7,893,564 Comments

Discussions

extend DBMS_XPLAN.DISPLAY% functions by an ORDER column

berx
berx Member Posts: 219 Silver Badge
edited Nov 27, 2021 12:55PM in Database Ideas - Ideas

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.

berxErik van Roon
2 votes

Active · Last Updated