dblink

Hi,

I have a query that queries this table with a range condition on PROD/STANDBY:

If I run the query locally, this is the result:

SELECT count(1)
  FROM big_table CDRS
 WHERE (CDRS.CALLING_NUMBER = '3104660300' OR
       CDRS.CALLING_NUMBER = '573104660300')
   AND CDRS.CALL_TYPE = 1
   AND CDRS.START_TIME BETWEEN
       TO_DATE('20/03/2010 00:00:01', 'DD/MM/YYYY HH24:MI:SS') AND
       TO_DATE('27/03/2010 23:59:59', 'DD/MM/YYYY HH24:MI:SS');

returns in: 0,016 second

I run the same query over DBLINK, this is the result:

SELECT count(1)
  FROM big_table@dbl_rpstr CDRS
 WHERE (CDRS.CALLING_NUMBER = '3104660300' OR