query optimization - ignore the previos one

sorry if this is a newbe question

i have this query

select PAGO.*, PAGOTELEFONO.*, REVERSION.* from REVERSION, PAGOTELEFONO, PAGO, NOTA, CAJA where 75 = CAJA.IDRECAUDADOR AND CAJA.IDCAJA = NOTA.IDCAJA AND NOTA.IDNOTA = PAGO.IDNOTA AND PAGOTELEFONO.IDPAGO = PAGO.IDPAGO AND REVERSION.IDPAGO = PAGO.IDPAGO AND REVERSION.FECHAREVERSION >= to_date('20041025','yyyymmdd') AND REVERSION.FECHAREVERSION <= to_date('20041025','yyyymmdd')

with idRecaudador = 77 the query last 5 seg and return 2 row

with idRecaudador = 75 the query last 1 min 7 seg and return 1 row !!!!

any idea whats happening ??? why this response time difference only changing 1 parameter ???

thanks
Igancio Received on Tue Nov 30 2004 - 15:56:56 CST