1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| -------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 940 (100)| |
| 1 | HASH UNIQUE | | 8 | 328 | 940 (7)| 00:00:12 |
|* 2 | HASH JOIN | | 672K| 26M| 899 (2)| 00:00:11 |
|* 3 | TABLE ACCESS FULL | PSQUEUEDEFN | 73 | 1387 | 5 (0)| 00:00:01 |
|* 4 | INDEX FAST FULL SCAN| PSDPSAPMSGPUBHDR | 672K| 14M| 889 (2)| 00:00:11 |
-------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1
3 - SEL$1 / B@SEL$1
4 - SEL$1 / A@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
OPT_PARAM('_optimizer_cost_based_transformation' 'off')
OUTLINE_LEAF(@"SEL$1")
FULL(@"SEL$1" "B"@"SEL$1")
INDEX_FFS(@"SEL$1" "A"@"SEL$1" ("PSAPMSGPUBHDR"."PUBSTATUS"
"PSAPMSGPUBHDR"."QUEUENAME"))
LEADING(@"SEL$1" "B"@"SEL$1" "A"@"SEL$1")
USE_HASH(@"SEL$1" "A"@"SEL$1")
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("A"."QUEUENAME"="B"."QUEUENAME")
3 - filter("B"."QUEUESTATUS"<>2)
4 - filter(("PUBSTATUS"=1 OR "PUBSTATUS"=2))
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "A"."QUEUENAME"[VARCHAR2,120]
2 - (#keys=1) "A"."QUEUENAME"[VARCHAR2,120]
3 - "B"."QUEUENAME"[VARCHAR2,120]
4 - "A"."QUEUENAME"[VARCHAR2,120] |
Partager