Execution Plan
----------------------------------------------------------
Plan hash value: 1546262234

--------------------------------------------------------------------------------------------------------
| Id  | Operation                       | Name                 | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                |                      |     1 |    81 |   109   (1)| 00:00:06 |
|   1 |  SORT GROUP BY                  |                      |     1 |    81 |            |          |
|   2 |   NESTED LOOPS ANTI             |                      |     1 |    81 |   109   (1)| 00:00:06 |
|   3 |    MERGE JOIN CARTESIAN         |                      |     1 |    70 |   108   (1)| 00:00:06 |
|   4 |     NESTED LOOPS                |                      |     1 |    59 |   105   (1)| 00:00:05 |
|*  5 |      TABLE ACCESS FULL          | IMMOB2B_MEMBER       |     1 |    26 |   104   (1)| 00:00:05 |
|   6 |      TABLE ACCESS BY INDEX ROWID| IMMOB2B_MEMBER       |     1 |    33 |     1   (0)| 00:00:01 |
|*  7 |       INDEX UNIQUE SCAN         | PK_IMMOB2B_MEMBER    |     1 |       |     0   (0)| 00:00:01 |
|   8 |     BUFFER SORT                 |                      |     1 |    11 |   107   (1)| 00:00:05 |
|   9 |      TABLE ACCESS BY INDEX ROWID| CAMPAGNE             |     1 |    11 |     3   (0)| 00:00:01 |
|* 10 |       INDEX RANGE SCAN          | IDX_CAMPAGNE_MESSAGE |     1 |       |     2   (0)| 00:00:01 |
|* 11 |    INDEX UNIQUE SCAN            | PK_IMMOB2B_REPORT    | 65069 |   698K|     1   (0)| 00:00:01 |
--------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   5 - 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)   7 - access("M1"."MEMBER_ID"="IMMOB2B_MEMBER"."MEMBER_ID")
  10 - access("MESSAGE_ID"=939277)
  11 - access("SP_RC"."CAMPAGNE_ID"="CAMPAGNE_ID" AND
              "IMMOB2B_MEMBER"."MEMBER_ID"="SP_RC"."MEMBER_ID")


Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
      60621  consistent gets
          0  physical reads
          0  redo size
        533  bytes sent via SQL*Net to client
        488  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          2  sorts (memory)
          0  sorts (disk)
          1  rows processed