Skip to content

Instantly share code, notes, and snippets.

@wmene

wmene/slow-explain-plan

Created July 26, 2014 00:32
Show Gist options
  • Save wmene/551fa4ca2617fbc57137 to your computer and use it in GitHub Desktop.
Save wmene/551fa4ca2617fbc57137 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
slow-explain-plan
--------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
--------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 478 | 94644 | 1530 |
| 1 | SORT ORDER BY | | 478 | 94644 | 1530 |
| 2 | HASH JOIN | | 478 | 94644 | 1529 |
| 3 | HASH JOIN | | 403 | 55614 | 877 |
| 4 | TABLE ACCESS BY INDEX ROWID | WORKFLOW | 345 | 26910 | 285 |
| 5 | BITMAP CONVERSION TO ROWIDS | | | | |
| 6 | BITMAP AND | | | | |
| 7 | BITMAP CONVERSION FROM ROWIDS| | | | |
| 8 | INDEX RANGE SCAN | PROCESS_WF_IDX | 9671 | | 30 |
| 9 | BITMAP CONVERSION FROM ROWIDS| | | | |
| 10 | INDEX RANGE SCAN | LANE_ID_WF_IDX | 9671 | | 69 |
| 11 | BITMAP CONVERSION FROM ROWIDS| | | | |
| 12 | INDEX RANGE SCAN | STATUS_WF_IDX | 9671 | | 74 |
| 13 | TABLE ACCESS BY INDEX ROWID | WORKFLOW | 1868 | 109K| 591 |
| 14 | INDEX RANGE SCAN | PROCESS_WF_IDX | 3191 | | 29 |
| 15 | TABLE ACCESS BY INDEX ROWID | WORKFLOW | 2055 | 120K| 651 |
| 16 | INDEX RANGE SCAN | PROCESS_WF_IDX | 3511 | | 32 |
--------------------------------------------------------------------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment