Plan SELECT STATEMENT ALL_ROWSCost: 6,916 Bytes: 29,374,450 Cardinality: 2,225 62 SORT ORDER BY Cost: 6,916 Bytes: 29,374,450 Cardinality: 2,225 61 FILTER 60 VIEW VIEW APPWORX.AW_JOB_ACTIVITY Cost: 805 Bytes: 29,374,450 Cardinality: 2,225 59 SORT UNIQUE Cost: 805 Bytes: 1,247,334 Cardinality: 2,225 58 UNION-ALL 26 FILTER 25 HASH JOIN RIGHT OUTER Cost: 526 Bytes: 1,240,992 Cardinality: 2,224 1 TABLE ACCESS FULL TABLE APPWORX.SO_APPLS Cost: 3 Bytes: 161 Cardinality: 7 24 HASH JOIN RIGHT OUTER Cost: 523 Bytes: 1,188,235 Cardinality: 2,221 2 TABLE ACCESS FULL TABLE APPWORX.SO_CHAIN_DETAIL Cost: 5 Bytes: 32,830 Cardinality: 469 23 HASH JOIN RIGHT OUTER Cost: 517 Bytes: 1,032,765 Cardinality: 2,221 3 TABLE ACCESS FULL TABLE APPWORX.SO_JOB_TABLE Cost: 7 Bytes: 374 Cardinality: 22 22 HASH JOIN RIGHT OUTER Cost: 510 Bytes: 995,008 Cardinality: 2,221 4 TABLE ACCESS FULL TABLE APPWORX.SO_COMMAND_PATHS Cost: 3 Bytes: 703 Cardinality: 19 21 HASH JOIN RIGHT OUTER Cost: 506 Bytes: 912,831 Cardinality: 2,221 8 VIEW VIEW APPWORX.index$_join$_008 Cost: 3 Bytes: 60 Cardinality: 4 7 HASH JOIN 5 INDEX FAST FULL SCAN INDEX (UNIQUE) APPWORX.AW_MODULE_SCHED_U_IDX Cost: 1 Bytes: 60 Cardinality: 4 6 INDEX FAST FULL SCAN INDEX (UNIQUE) APPWORX.PK_AW_MODULE_SCHED Cost: 1 Bytes: 60 Cardinality: 4 20 FILTER 19 HASH JOIN RIGHT OUTER Cost: 503 Bytes: 879,516 Cardinality: 2,221 9 TABLE ACCESS FULL TABLE APPWORX.SO_JOB_TABLE Cost: 7 Bytes: 93,666 Cardinality: 699 18 HASH JOIN RIGHT OUTER Cost: 496 Bytes: 582,688 Cardinality: 2,224 13 VIEW VIEW APPWORX.index$_join$_011 Cost: 3 Bytes: 30 Cardinality: 3 12 HASH JOIN 10 INDEX FAST FULL SCAN INDEX (UNIQUE) APPWORX.SO_USER_TABLE_IDX Cost: 1 Bytes: 30 Cardinality: 3 11 INDEX FAST FULL SCAN INDEX (UNIQUE) APPWORX.SO_USER_TABLE_IDX1 Cost: 1 Bytes: 30 Cardinality: 3 17 HASH JOIN Cost: 493 Bytes: 560,448 Cardinality: 2,224 15 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_JOB_QUEUE_ACTIVITY Cost: 9 Bytes: 22,240 Cardinality: 2,224 14 INDEX RANGE SCAN INDEX APPWORX.AW_JOB_QUEUE_ACTIVITY_IDX1 Cost: 4 Cardinality: 400 16 TABLE ACCESS FULL TABLE APPWORX.SO_JOB_HISTORY Cost: 483 Bytes: 10,797,556 Cardinality: 44,618 57 FILTER 56 NESTED LOOPS OUTER Cost: 12 Bytes: 6,342 Cardinality: 1 53 NESTED LOOPS OUTER Cost: 12 Bytes: 6,312 Cardinality: 1 50 NESTED LOOPS OUTER Cost: 11 Bytes: 6,275 Cardinality: 1 47 FILTER 46 NESTED LOOPS OUTER Cost: 10 Bytes: 6,252 Cardinality: 1 43 NESTED LOOPS OUTER Cost: 10 Bytes: 6,118 Cardinality: 1 40 NESTED LOOPS OUTER Cost: 9 Bytes: 6,048 Cardinality: 1 37 NESTED LOOPS OUTER Cost: 9 Bytes: 6,021 Cardinality: 1 34 NESTED LOOPS OUTER Cost: 9 Bytes: 6,006 Cardinality: 1 31 NESTED LOOPS Cost: 9 Bytes: 5,996 Cardinality: 1 28 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_JOB_QUEUE_ACTIVITY Cost: 9 Bytes: 22,240 Cardinality: 2,224 27 INDEX RANGE SCAN INDEX APPWORX.AW_JOB_QUEUE_ACTIVITY_IDX1 Cost: 4 Cardinality: 400 30 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_QUEUE Cost: 0 Bytes: 5,986 Cardinality: 1 29 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_QUEUE_IDX Cost: 0 Cardinality: 1 33 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_USER_TABLE Cost: 0 Bytes: 10 Cardinality: 1 32 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_USER_TABLE_IDX Cost: 0 Cardinality: 1 36 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_MODULE_SCHED Cost: 0 Bytes: 15 Cardinality: 1 35 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.PK_AW_MODULE_SCHED Cost: 0 Cardinality: 1 39 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE Cost: 0 Bytes: 27 Cardinality: 1 38 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX Cost: 0 Cardinality: 1 42 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_CHAIN_DETAIL Cost: 1 Bytes: 70 Cardinality: 1 41 INDEX RANGE SCAN INDEX APPWORX.SO_CHAIN_DETAIL_IDX2 Cost: 1 Cardinality: 1 45 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE Cost: 0 Bytes: 134 Cardinality: 1 44 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX Cost: 0 Cardinality: 1 49 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_APPLS Cost: 1 Bytes: 23 Cardinality: 1 48 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_APPLS_IDX Cost: 0 Cardinality: 1 52 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_COMMAND_PATHS Cost: 1 Bytes: 37 Cardinality: 1 51 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_COMMAND_PATHS_IDX Cost: 0 Cardinality: 1 55 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_QUEUE Cost: 0 Bytes: 30 Cardinality: 1 54 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_QUEUE_IDX Cost: 0 Cardinality: 1