Plan SELECT STATEMENT ALL_ROWSCost: 25 Bytes: 39,606 Cardinality: 3 64 SORT ORDER BY Cost: 25 Bytes: 39,606 Cardinality: 3 63 FILTER 62 VIEW VIEW APPWORX.AW_JOB_ACTIVITY Cost: 24 Bytes: 39,606 Cardinality: 3 61 SORT UNIQUE Cost: 24 Bytes: 7,330 Cardinality: 3 60 UNION-ALL 28 FILTER 27 NESTED LOOPS OUTER Cost: 17 Bytes: 990 Cardinality: 2 24 NESTED LOOPS OUTER Cost: 15 Bytes: 916 Cardinality: 2 21 FILTER 20 NESTED LOOPS OUTER Cost: 13 Bytes: 870 Cardinality: 2 17 NESTED LOOPS OUTER Cost: 11 Bytes: 602 Cardinality: 2 14 NESTED LOOPS OUTER Cost: 10 Bytes: 568 Cardinality: 2 11 NESTED LOOPS OUTER Cost: 8 Bytes: 428 Cardinality: 2 8 NESTED LOOPS OUTER Cost: 6 Bytes: 398 Cardinality: 2 5 NESTED LOOPS Cost: 4 Bytes: 378 Cardinality: 2 2 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_JOB_QUEUE_ACTIVITY Cost: 2 Bytes: 16 Cardinality: 2 1 INDEX RANGE SCAN INDEX APPWORX.AW_JOB_QUEUE_ACTIVITY_IDX1 Cost: 1 Cardinality: 2 4 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_HISTORY Cost: 1 Bytes: 181 Cardinality: 1 3 INDEX RANGE SCAN INDEX APPWORX.SO_JOB_HISTORY_IDX1 Cost: 0 Cardinality: 1 7 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_USER_TABLE Cost: 1 Bytes: 10 Cardinality: 1 6 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_USER_TABLE_IDX Cost: 0 Cardinality: 1 10 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_MODULE_SCHED Cost: 1 Bytes: 15 Cardinality: 1 9 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.PK_AW_MODULE_SCHED Cost: 0 Cardinality: 1 13 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_CHAIN_DETAIL Cost: 2 Bytes: 70 Cardinality: 1 12 INDEX RANGE SCAN INDEX APPWORX.SO_CHAIN_DETAIL_IDX2 Cost: 1 Cardinality: 1 16 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE Cost: 1 Bytes: 17 Cardinality: 1 15 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX Cost: 0 Cardinality: 1 19 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE Cost: 1 Bytes: 134 Cardinality: 1 18 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX Cost: 0 Cardinality: 1 23 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_APPLS Cost: 1 Bytes: 23 Cardinality: 1 22 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_APPLS_IDX Cost: 0 Cardinality: 1 26 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_COMMAND_PATHS Cost: 1 Bytes: 37 Cardinality: 1 25 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_COMMAND_PATHS_IDX Cost: 0 Cardinality: 1 59 FILTER 58 NESTED LOOPS OUTER Cost: 5 Bytes: 6,340 Cardinality: 1 55 NESTED LOOPS OUTER Cost: 5 Bytes: 6,310 Cardinality: 1 52 NESTED LOOPS OUTER Cost: 4 Bytes: 6,273 Cardinality: 1 49 FILTER 48 NESTED LOOPS OUTER Cost: 3 Bytes: 6,250 Cardinality: 1 45 NESTED LOOPS OUTER Cost: 3 Bytes: 6,116 Cardinality: 1 42 NESTED LOOPS OUTER Cost: 2 Bytes: 6,046 Cardinality: 1 39 NESTED LOOPS OUTER Cost: 2 Bytes: 6,019 Cardinality: 1 36 NESTED LOOPS OUTER Cost: 2 Bytes: 6,004 Cardinality: 1 33 NESTED LOOPS Cost: 2 Bytes: 5,994 Cardinality: 1 30 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_JOB_QUEUE_ACTIVITY Cost: 2 Bytes: 16 Cardinality: 2 29 INDEX RANGE SCAN INDEX APPWORX.AW_JOB_QUEUE_ACTIVITY_IDX1 Cost: 1 Cardinality: 2 32 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_QUEUE Cost: 0 Bytes: 5,986 Cardinality: 1 31 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_QUEUE_IDX Cost: 0 Cardinality: 1 35 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_USER_TABLE Cost: 0 Bytes: 10 Cardinality: 1 34 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_USER_TABLE_IDX Cost: 0 Cardinality: 1 38 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.AW_MODULE_SCHED Cost: 0 Bytes: 15 Cardinality: 1 37 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.PK_AW_MODULE_SCHED Cost: 0 Cardinality: 1 41 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE Cost: 0 Bytes: 27 Cardinality: 1 40 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX Cost: 0 Cardinality: 1 44 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_CHAIN_DETAIL Cost: 1 Bytes: 70 Cardinality: 1 43 INDEX RANGE SCAN INDEX APPWORX.SO_CHAIN_DETAIL_IDX2 Cost: 1 Cardinality: 1 47 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_TABLE Cost: 0 Bytes: 134 Cardinality: 1 46 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_TABLE_IDX Cost: 0 Cardinality: 1 51 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_APPLS Cost: 1 Bytes: 23 Cardinality: 1 50 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_APPLS_IDX Cost: 0 Cardinality: 1 54 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_COMMAND_PATHS Cost: 1 Bytes: 37 Cardinality: 1 53 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_COMMAND_PATHS_IDX Cost: 0 Cardinality: 1 57 TABLE ACCESS BY INDEX ROWID TABLE APPWORX.SO_JOB_QUEUE Cost: 0 Bytes: 30 Cardinality: 1 56 INDEX UNIQUE SCAN INDEX (UNIQUE) APPWORX.SO_JOB_QUEUE_IDX Cost: 0 Cardinality: 1