Host variable

From: <vidvas_at_hotmail.com>
Date: 2000/08/07
Message-ID: <8mnh2f$sjf$1@nnrp1.deja.com>#1/1

I've a query joining 2 tables. Here's the query.

SELECT distinct a.ID

       from  a,b
       where a.id = b.acct_id
       and  ( a.Modified_date >= (to_date(:zdate),'YYYYMMDDHH24MISS'))
        or  ( b.Modified_date >= (to_date(:zdate,'YYYYMMDDHH24MISS'))))

If host variable is used, it takes 3 - 4 hours to give the results. and when i hard code the date parameter, it takes only acouple of minutes. Any suggestions?

thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 07 2000 - 00:00:00 CDT