- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.8K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
extend DBMS_XPLAN.DISPLAY% functions by an ORDER column
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.