Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Host variable
Probably using host variables disables using indexes? Can you explain plan?
BTW, you're missing a ")" on the last line.
Yong Huang
<vidvas_at_hotmail.com> wrote in message news:8mnh2f$sjf$1_at_nnrp1.deja.com...
> 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 14 2000 - 15:39:15 CDT