Re: Host variable

From: holders <holders_at_demon.co.uk>
Date: 2000/08/08
Message-ID: <39901AC8.49E8DD0@demon.co.uk>#1/1

Hello,

My assumption here is that you are using the cost based optimizer. The problem with bind variables is that the optimizer does not its values and therefore cannot use all gather statistics as opposed to a literal SQL for which it does
SH.

vidvas_at_hotmail.com wrote:

> 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 Tue Aug 08 2000 - 00:00:00 CDT