FIRST QUERY PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 69751123 -------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | -------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 5018 | 297 (2)| 00:00:05 | | | |* 1 | COUNT STOPKEY | | | | | | | | |* 2 | FILTER | | | | | | | | | 3 | VIEW | | 1 | 5018 | 297 (2)| 00:00:05 | | | | 4 | SORT ORDER BY | | 1 | 138 | 297 (2)| 00:00:05 | | | |* 5 | HASH JOIN ANTI | | 1 | 138 | 281 (2)| 00:00:04 | | | | 6 | INLIST ITERATOR | | | | | | | | |* 7 | TABLE ACCESS BY GLOBAL INDEX ROWID | TRIGGERS | 9 | 1197 | 140 (0)| 00:00:02 | ROWID | ROWID | |* 8 | INDEX RANGE SCAN | TRIGGERS_IDX$$_46BE0008 | 374 | | 31 (0)| 00:00:01 | | | |* 9 | FILTER | | | | | | | | | 10 | HASH GROUP BY | | 2 | 78 | 16 (13)| 00:00:01 | | | |* 11 | HASH JOIN OUTER | | 13 | 507 | 15 (7)| 00:00:01 | | | | 12 | NESTED LOOPS | | 7 | 203 | 10 (0)| 00:00:01 | | | | 13 | NESTED LOOPS | | 4 | 80 | 6 (0)| 00:00:01 | | | |* 14 | INDEX RANGE SCAN | FUNCTIONS_IDX$$_46BE0001 | 4 | 40 | 2 (0)| 00:00:01 | | | | 15 | TABLE ACCESS BY GLOBAL INDEX ROWID| ITEMS | 1 | 10 | 1 (0)| 00:00:01 | ROWID | ROWID | |* 16 | INDEX UNIQUE SCAN | SYS_C0018113 | 1 | | 0 (0)| 00:00:01 | | | |* 17 | INDEX RANGE SCAN | HOSTS_GROUPS_1 | 2 | 18 | 1 (0)| 00:00:01 | | | |* 18 | TABLE ACCESS FULL | RIGHTS | 317 | 3170 | 4 (0)| 00:00:01 | | | | 19 | VIEW | VW_SQ_1 | 9190 | 45950 | 140 (2)| 00:00:02 | | | |* 20 | HASH JOIN | | 9190 | 278K| 140 (2)| 00:00:02 | | | |* 21 | HASH JOIN | | 13507 | 276K| 90 (2)| 00:00:02 | | | | 22 | INDEX FAST FULL SCAN | HOSTS_IDX$$_607B0015 | 2092 | 16736 | 4 (0)| 00:00:01 | | | | 23 | INDEX FAST FULL SCAN | IDX$$_476D0002 | 49200 | 624K| 85 (0)| 00:00:02 | | | | 24 | INDEX FAST FULL SCAN | FUNCTIONS_IDX$$_607B001F | 33475 | 326K| 49 (0)| 00:00:01 | | | -------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<=40) 2 - filter(ROWNUM>=0) 5 - access("T"."TRIGGERID"="ITEM_1") 7 - filter("T"."VALUE"=1) 8 - access("T"."STATUS"=0 AND ("T"."FLAGS"=0 OR "T"."FLAGS"=4) AND ("T"."PRIORITY"=2 OR "T"."PRIORITY"=3 OR "T"."PRIORITY"=4 OR "T"."PRIORITY"=5)) filter( NOT EXISTS (SELECT 0 FROM "RIGHTS" "R","HOSTS_GROUPS" "HGG","ITEMS" "I","FUNCTIONS" "F" WHERE "F"."TRIGGERID"=:B1 AND "F"."ITEMID"="I"."ITEMID" AND "I"."HOSTID"="HGG"."HOSTID" AND "R"."ID"(+)="HGG"."GROUPID" AND ("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) GROUP BY "I"."HOSTID" HAVING MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0)) 9 - filter(MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0) 11 - access("R"."ID"(+)="HGG"."GROUPID") 14 - access("F"."TRIGGERID"=:B1) 16 - access("F"."ITEMID"="I"."ITEMID") 17 - access("I"."HOSTID"="HGG"."HOSTID") 18 - filter("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) 20 - access("F"."ITEMID"="I"."ITEMID") 21 - access("I"."HOSTID"="H"."HOSTID") filter("I"."STATUS"<>0 OR "H"."STATUS"<>0) 54 rows selected. SECOND QUERY PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Plan hash value: 2395199631 ----------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ----------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 30 | 296 (2)| 00:00:05 | | | | 1 | SORT GROUP BY | | 1 | 30 | | | | | |* 2 | HASH JOIN ANTI | | 1 | 30 | 281 (2)| 00:00:04 | | | | 3 | INLIST ITERATOR | | | | | | | | |* 4 | TABLE ACCESS BY GLOBAL INDEX ROWID | TRIGGERS | 9 | 153 | 140 (0)| 00:00:02 | ROWID | ROWID | |* 5 | INDEX RANGE SCAN | TRIGGERS_IDX$$_46BE0008 | 374 | | 31 (0)| 00:00:01 | | | |* 6 | FILTER | | | | | | | | | 7 | HASH GROUP BY | | 2 | 78 | 16 (13)| 00:00:01 | | | |* 8 | HASH JOIN OUTER | | 13 | 507 | 15 (7)| 00:00:01 | | | | 9 | NESTED LOOPS | | 7 | 203 | 10 (0)| 00:00:01 | | | | 10 | NESTED LOOPS | | 4 | 80 | 6 (0)| 00:00:01 | | | |* 11 | INDEX RANGE SCAN | FUNCTIONS_IDX$$_46BE0001 | 4 | 40 | 2 (0)| 00:00:01 | | | | 12 | TABLE ACCESS BY GLOBAL INDEX ROWID| ITEMS | 1 | 10 | 1 (0)| 00:00:01 | ROWID | ROWID | |* 13 | INDEX UNIQUE SCAN | SYS_C0018113 | 1 | | 0 (0)| 00:00:01 | | | |* 14 | INDEX RANGE SCAN | HOSTS_GROUPS_1 | 2 | 18 | 1 (0)| 00:00:01 | | | |* 15 | TABLE ACCESS FULL | RIGHTS | 317 | 3170 | 4 (0)| 00:00:01 | | | | 16 | VIEW | VW_SQ_1 | 9190 | 116K| 140 (2)| 00:00:02 | | | |* 17 | HASH JOIN | | 9190 | 278K| 140 (2)| 00:00:02 | | | |* 18 | HASH JOIN | | 13507 | 276K| 90 (2)| 00:00:02 | | | | 19 | INDEX FAST FULL SCAN | HOSTS_IDX$$_607B0015 | 2092 | 16736 | 4 (0)| 00:00:01 | | | | 20 | INDEX FAST FULL SCAN | IDX$$_476D0002 | 49200 | 624K| 85 (0)| 00:00:02 | | | | 21 | INDEX FAST FULL SCAN | FUNCTIONS_IDX$$_607B001F | 33475 | 326K| 49 (0)| 00:00:01 | | | ----------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - access("T"."TRIGGERID"="ITEM_1") 4 - filter("T"."VALUE"=1) 5 - access("T"."STATUS"=0 AND ("T"."FLAGS"=0 OR "T"."FLAGS"=4) AND ("T"."PRIORITY"=2 OR "T"."PRIORITY"=3 OR "T"."PRIORITY"=4 OR "T"."PRIORITY"=5)) filter( NOT EXISTS (SELECT 0 FROM "RIGHTS" "R","HOSTS_GROUPS" "HGG","ITEMS" "I","FUNCTIONS" "F" WHERE "F"."TRIGGERID"=:B1 AND "F"."ITEMID"="I"."ITEMID" AND "I"."HOSTID"="HGG"."HOSTID" AND "R"."ID"(+)="HGG"."GROUPID" AND ("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) GROUP BY "I"."HOSTID" HAVING MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0)) 6 - filter(MAX("R"."PERMISSION")<2 OR MIN("R"."PERMISSION") IS NULL OR MIN("R"."PERMISSION")=0) 8 - access("R"."ID"(+)="HGG"."GROUPID") 11 - access("F"."TRIGGERID"=:B1) 13 - access("F"."ITEMID"="I"."ITEMID") 14 - access("I"."HOSTID"="HGG"."HOSTID") 15 - filter("R"."GROUPID"(+)=13 OR "R"."GROUPID"(+)=25) 17 - access("F"."ITEMID"="I"."ITEMID") 18 - access("I"."HOSTID"="H"."HOSTID") filter("I"."STATUS"<>0 OR "H"."STATUS"<>0) 49 rows selected.