RI_LST_ID = T15.ROW_ID (+) AND
220 T5.ROW_ID = T17.CONTACT_ID (+) AND
221 T19.PR_EMP_ID = T23.PAR_ROW_ID (+) AND
222 T19.PR_EMP_ID = T29.PAR_ROW_ID (+) AND
223 T5.ROW_ID = T33.PAR_ROW_ID AND
224 T5.ROW_ID = T18.PAR_ROW_ID (+) AND
225 T5.ROW_ID = T20.PAR_ROW_ID (+) AND
226 T5.ROW_ID = T9.PAR_ROW_ID (+) AND
227 T5.ROW_ID = T7.PAR_ROW_ID (+) AND
228 T33.PR_POSTN_ID = T27.POSTN_ID AND T33.ROW_ID = T27.CON_ID AND
229 T27.POSTN_ID = T25.ROW_ID AND
230 T27.POSTN_ID = T12.PAR_ROW_ID (+) AND
231 T12.PR_EMP_ID = T24.PAR_ROW_ID (+) AND
232 T33.PR_DEPT_OU_ID = T3.ROW_ID (+) AND
233 T33.PR_DEPT_OU_ID = T10.PAR_ROW_ID (+) AND
234 T33.PR_DEPT_OU_ID = T16.PAR_ROW_ID (+) AND
235 T33.PR_PER_ADDR_ID = T6.ADDR_PER_ID (+) AND T33.ROW_ID = T6.CONTACT_ID (+) AND
236 T33.PR_PER_ADDR_ID = T11.ROW_ID (+) AND
237 T33.PR_SYNC_USER_ID = T14.ROW_ID (+) AND
238 T33.PR_SYNC_USER_ID = T8.PAR_ROW_ID (+) AND
239 T1.BU_ID = '1234' AND T33.ROW_ID = T1.CONTACT_ID AND
240 T1.BU_ID = T13.ROW_ID AND
241 ((T33.PRIV_FLG = 'N' AND T5.PARTY_TYPE_CD != 'Suspect' AND T1.CON_EMP_FLG = 'N') AND
242 (T1.CON_LAST_NAME >= 'M0808594')) AND
243 (T33.CELL_PH_NUM LIKE '13912345678')
244 ORDER BY
245 T1.BU_ID, T1.CON_LAST_NAME, T1.CON_FST_NAME
246 ;
no ROWS selected
Execution Plan
----------------------------------------------------------
Plan hash VALUE: 4013657437
----------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | ROWS | Bytes | Cost (%CPU)| TIME |
----------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2 | 5474 | 36 (6)| 00:00:01 |
| 1 | SORT ORDER BY | | 2 | 5474 | 36 (6)| 00:00:01 |
| 2 | NESTED LOOPS OUTER | | 2 | 5474 | 35 (3)| 00:00:01 |
| 3 | NESTED LOOPS OUTER | | 2 | 5434 | 34 (3)| 00:00:01 |
| 4 | NESTED LOOPS OUTER | | 2 | 5394 | 33 (4)| 00:00:01 |
| 5 | NESTED LOOPS OUTER | | 2 | 5354 | 32 (4)| 00:00:01 |
| 6 | NESTED LOOPS OUTER | | 2 | 5314 | 31 (4)| 00:00:01 |
| 7 | NESTED LOOPS OUTER | | 2 | 5274 | 30 (4)| 00:00:01 |
| 8 | NESTED LOOPS | | 2 | 5234 | 29 (4)| 00:00:01 |
| 9 | NESTED LOOPS OUTER | | 2 | 5212 | 28 (4)| 00:00:01 |
| 10 | NESTED LOOPS OUTER | | |