|* 89 | INDEX UNIQUE SCAN | S_USER_U2 | 1 | | 1 (0)| 00:00:01 |
| 90 | TABLE ACCESS BY INDEX ROWID | S_USER | 1 | 20 | 1 (0)| 00:00:01 |
|* 91 | INDEX UNIQUE SCAN | S_USER_U2 | 1 | | 1 (0)| 00:00:01 |
| 92 | TABLE ACCESS BY INDEX ROWID | S_USER | 1 | 20 | 1 (0)| 00:00:01 |
|* 93 | INDEX UNIQUE SCAN | S_USER_U2 | 1 | | 1 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------------------------------------
Predicate Information (IDENTIFIED BY operation id):
---------------------------------------------------
15 - access("T5"."ROW_ID"="T22"."PR_SUBJECT_ID"(+))
34 - access("T13"."ROW_ID"='1234')
35 - FILTER("T33"."PRIV_FLG"='N')
36 - access("T33"."CELL_PH_NUM"='13912345678')
38 - access("T33"."CURR_PRI_LST_ID"="T15"."ROW_ID"(+))
40 - access("T33"."MED_SPEC_ID"="T4"."ROW_ID"(+))
41 - FILTER("T1"."CON_LAST_NAME">='M0808594' AND "T1"."CON_EMP_FLG"='N')
42 - access("T33"."ROW_ID"="T1"."CONTACT_ID" AND "T1"."BU_ID"='1234')
44 - access("T33"."PR_POSTN_ID"="T19"."PAR_ROW_ID"(+))
46 - access("T33"."PR_DEPT_OU_ID"="T16"."PAR_ROW_ID"(+))
48 - access("T33"."PR_DEPT_OU_ID"="T10"."PAR_ROW_ID"(+))
50 - access("T33"."PR_DEPT_OU_ID"="T2"."PAR_ROW_ID"(+))
52 - access("T2"."PR_POSTN_ID"="T30"."PAR_ROW_ID"(+))
54 - access("T33"."BU_ID"="T32"."PAR_ROW_ID"(+))
55 - FILTER("T33"."PR_PER_ADDR_ID"="T6"."ADDR_PER_ID"(+))
56 - access("T33"."ROW_ID"="T6"."CONTACT_ID"(+))
FILTER("T6"."CONTACT_ID"(+) IS NOT NULL)
58 - access("T33"."PR_PER_ADDR_ID"="T31"."ROW_ID"(+))
60 - access("T33"."PR_PER_ADDR_ID"="T11"."ROW_ID"(+))
62 - access("T33"."PR_POSTN_ID"="T27"."POSTN_ID" AND "T33"."ROW_ID"="T27"."CON_ID")
64 - access("T27"."POSTN_ID"="T12"."PAR_ROW_ID"(+))
65 - FILTER("T5"."PARTY_TYPE_CD"<>'Suspect')
66 - access("T5"."ROW_ID"="T33"."PAR_ROW_ID")
67 - access("T5"."ROW_ID"="T17"."CONTACT_ID"(+))
69 - access("T5"."ROW_ID"="T7"."PAR_ROW_ID"(+))
72 - access("T5"."ROW_ID"="T9"."PAR_ROW_ID"(+))
74 - access("T28"."POSTN_ID"(+)='1234' AND "T5"."ROW_ID"="T28"."CON_ID"(+))
76 - access("T5"."ROW_ID"="T20"."PAR_ROW_ID"(+))
78 - access("T5"."ROW_ID"="T18"."PAR_ROW_ID"(+))
79 - access("T33"."PR_SYNC_USER_ID"="T14"."ROW_ID"(+))
80 - access("T33"."PR_DEPT_OU_ID"="T3"."ROW_ID"(+))
81 - access("T27"."POSTN_ID"="T25"."ROW_ID")
83 - access("T33"."PR_SYNC_USER_ID"="T8"."PAR_ROW_ID"(+))
85 - access("T19"."PR_EMP_ID"="T29"."PAR_ROW_ID"(+))
87 - access("T19"."PR_EMP_ID"="T26"."PAR_ROW_ID"(+))
89 - access("T19"."PR_EMP_ID"="T23"."PAR_ROW_ID"(+))
91 - access("T30"."PR_EMP_ID"="T21"."PAR_ROW_ID"(+))
93 - access("T12"."PR_EMP_ID"="T24"."PAR_ROW_ID"(+))
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
3 consistent gets
0 physical reads
0 redo SIZE
12616 bytes sent |