<CODE>
SELECT COUNT (1)
  FROM rt_rate_udf r1, rt_rate_udf r2
 WHERE r1.rate_id = 132733
   AND r2.rate_id = 132733
   AND r1.udf_id = r2.udf_id
   AND NVL (r1.udf_value_int, -0.1) = NVL (r2.udf_value_int, -0.1)
   AND NVL (r1.udf_value_dbl, -0.1) = NVL (r2.udf_value_dbl, -0.1)
   AND NVL (r1.udf_value_dt, TO_DATE ('01/01/1000', 'DD/MM/YYYY')) =
                   NVL (r2.udf_value_dt, TO_DATE ('01/01/1000', 'DD/MM/YYYY'))
   AND NVL (r1.inclusive_flag, 'Y') = 'Y'
   AND NVL (r2.inclusive_flag, 'Y') = 'Y';
<CODE/>

Execution Plan
----------------------------------------------------------
   0       SELECT STATEMENT Optimizer Mode=ALL_ROWS (Cost=8 Card=1 Bytes=46)
   1    0    SORT AGGREGATE (Card=1 Bytes=46)
   2    1      TABLE ACCESS BY INDEX ROWID FXCRE_UAT1.RT_RATE_UDF (Cost=2 Card=1 Bytes=23)
   3    2        NESTED LOOPS (Cost=8 Card=1 Bytes=46)
   4    3          TABLE ACCESS BY INDEX ROWID FXCRE_UAT1.RT_RATE_UDF (Cost=4 Card=2 Bytes=46)
   5    4            INDEX RANGE SCAN FXCRE_UAT1.XAK1RT_RATE_UDF (Cost=3 Card=2)
   6    3          INDEX RANGE SCAN FXCRE_UAT1.XAK1RT_RATE_UDF (Cost=2 Card=1)

Statistics
----------------------------------------------------------
          1  recursive calls
          0  physical write total multi block requests
          0  gcs messages sent
          0  db block gets from cache
          0  redo entries
          0  java session heap live size
          0  java session heap live size max
          0  java session heap object count
          0  java session heap gc count
          0  java session heap collected count
          1  rows processed
          


<CODE>
SELECT COUNT (1)
  FROM rt_rate_udf r1, rt_rate_udf r2
 WHERE r1.rate_id = 132733
   AND r2.rate_id = 132733
   AND r1.udf_id = r2.udf_id
   AND (r1.udf_value_str = r2.udf_value_str
                    OR (r1.udf_value_str is null AND r2.udf_value_str is null))
   AND NVL (r1.udf_value_int, -0.1) = NVL (r2.udf_value_int, -0.1)
   AND NVL (r1.udf_value_dbl, -0.1) = NVL (r2.udf_value_dbl, -0.1)
   AND NVL (r1.udf_value_dt, TO_DATE ('01/01/1000', 'DD/MM/YYYY')) =
                   NVL (r2.udf_value_dt, TO_DATE ('01/01/1000', 'DD/MM/YYYY'))
   AND NVL (r1.inclusive_flag, 'Y') = 'Y'
   AND NVL (r2.inclusive_flag, 'Y') = 'Y';
<CODE/>

  COUNT(1)
----------
         2


1 row selected.

Execution Plan
----------------------------------------------------------
   0       SELECT STATEMENT Optimizer Mode=ALL_ROWS (Cost=8 Card=1 Bytes=46)
   1    0    SORT AGGREGATE (Card=1 Bytes=46)
   2    1      NESTED LOOPS (Cost=8 Card=1 Bytes=46)
   3    2        TABLE ACCESS BY INDEX ROWID FXCRE_UAT1.RT_RATE_UDF (Cost=4 Card=2 Bytes=46)
   4    3          INDEX RANGE SCAN FXCRE_UAT1.XAK1RT_RATE_UDF (Cost=3 Card=2)
   5    2        TABLE ACCESS BY INDEX ROWID FXCRE_UAT1.RT_RATE_UDF
   6    5          INDEX RANGE SCAN FXCRE_UAT1.XAK1RT_RATE_UDF (Cost=2 Card=1)

Statistics
----------------------------------------------------------
          1  recursive calls
          0  physical write total multi block requests
          0  gcs messages sent
          0  db block gets from cache
          0  redo entries
          0  java session heap live size
          0  java session heap live size max
          0  java session heap object count
          0  java session heap gc count
          0  java session heap collected count
          1  rows processed