1 - access("T2"."CUST_ID"="ITEM_1")
4 - filter("T3"."CUST_GENDER"='MALE')
5 - access(ROWID=ROWID)
7 - access("T3"."CUST_GENDER"='MALE')
9 - filter("T3"."CUST_GENDER"='FEMALE')
10 - access(ROWID=ROWID)
12 - access("T3"."CUST_GENDER"='FEMALE')
16 - filter("T1"."PROD_LIST_PRICE">1000)
19 - access("T1"."PROD_ID"="T2"."PROD_ID")
Statistics
----------------------------------------------------------
12 recursive calls
0 db block gets
14 consistent gets
0 physical reads
0 redo size
350 bytes sent via SQL*Net to client
404 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
4 sorts (memory)
0 sorts (disk)
0 rows processed