Plan hash value: 614474783
 
-------------------------------------------------------------------------------------------------------
| Id  | Operation                      | Name                 | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |                      |     1 |    81 |   183   (2)| 00:00:09 |
|   1 |  SORT GROUP BY                 |                      |     1 |    81 |            |          |
|   2 |   NESTED LOOPS                 |                      |    16 |  1296 |   183   (2)| 00:00:09 |
|*  3 |    HASH JOIN                   |                      |    16 |   768 |   167   (2)| 00:00:08 |
|   4 |     TABLE ACCESS BY INDEX ROWID| CAMPAGNE             |     1 |    11 |     4   (0)| 00:00:01 |
|*  5 |      INDEX RANGE SCAN          | IDX_CAMPAGNE_MESSAGE |     1 |       |     3   (0)| 00:00:01 |
|*  6 |     HASH JOIN ANTI             |                      |   499 | 18463 |   163   (2)| 00:00:08 |
|*  7 |      TABLE ACCESS FULL         | IMMOB2B_MEMBER       | 15530 |   394K|   104   (1)| 00:00:05 |
|   8 |      TABLE ACCESS FULL         | IMMOB2B_REPORT       |   146K|  1572K|    58   (0)| 00:00:03 |
|   9 |    TABLE ACCESS BY INDEX ROWID | IMMOB2B_MEMBER       |     1 |    33 |     1   (0)| 00:00:01 |
|* 10 |     INDEX UNIQUE SCAN          | PK_IMMOB2B_MEMBER    |     1 |       |     0   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("SP_RC"."CAMPAGNE_ID"="CAMPAGNE_ID")
   5 - access("MESSAGE_ID"=939277)
   6 - access("IMMOB2B_MEMBER"."MEMBER_ID"="SP_RC"."MEMBER_ID")
   7 - filter("IMMOB2B_MEMBER"."DATEUNJOIN" IS NULL AND ("IMMOB2B_MEMBER"."TYPECLIENT" NOT 
              LIKE '%prospect%' OR "IMMOB2B_MEMBER"."TYPECLIENT" IS NULL) AND ("IMMOB2B_MEMBER"."TYPECLIENT" 
              NOT LIKE '%web agence%' OR "IMMOB2B_MEMBER"."TYPECLIENT" IS NULL) AND 
              ("IMMOB2B_MEMBER"."TYPECLIENT" NOT LIKE '%paunitSL%' OR "IMMOB2B_MEMBER"."TYPECLIENT" IS NULL) 
              AND ("IMMOB2B_MEMBER"."TYPECLIENT" NOT LIKE '%usage interne%' OR "IMMOB2B_MEMBER"."TYPECLIENT" 
              IS NULL) AND ("IMMOB2B_MEMBER"."TYPECLIENT" NOT LIKE '%Un particulier%' OR 
              "IMMOB2B_MEMBER"."TYPECLIENT" IS NULL) AND ("IMMOB2B_MEMBER"."TYPECLIENT" NOT LIKE '%Agent 
              immobilier%' OR "IMMOB2B_MEMBER"."TYPECLIENT" IS NULL) AND "IMMOB2B_MEMBER"."EMVHBQ" IS NULL)
  10 - access("M1"."MEMBER_ID"="IMMOB2B_MEMBER"."MEMBER_ID")

   Statistics
-----------------------------------------------------------
               0  recursive calls
               0  db block gets
            1566  consistent gets
               0  physical reads
               0  redo size
               0  workarea executions - multipass
               0  parse time cpu
               0  parse time elapsed
               0  frame signature mismatch
               2  execute count