Re: immediate value vs bind variable

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 17 Jul 2002 13:22:17 +1000
Message-ID: <Ri5Z8.36470$Hj3.109862@newsfeeds.bigpond.com>

Hi Syltrem,

Just a little point. I hope meant varchar2 (and not varchar you stated) !

Regards

Richard
"Syltrem" <syltremspammenot_at_videotron.com> wrote in message news:IY%Y8.6315$H67.33359_at_tor-nn1.netcom.ca...
> Hi
>
> I don't know where to start looking in the doc to find the answer /
solution
> to this:
>
> a WHERE TABLE_COLUMN > bind_variable
> takes significantly longer than a
> WHERE TABLE_COLUMN > 'immediate value'
>
> The TABLE_COLUMN is a CHAR(2)
>
> Whether I declare the bind variable as a char or varchar don't make a
> difference, it's always longer when using the bind variable. Exapmle: 0.23
> seconds (immediate value) compared to 7.67 seconds (bind variable).
>
> Suggestions please!
>
> Thanks
> --
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
> To reply to myself directly, remove .spammenot from my address
>
>
>
Received on Tue Jul 16 2002 - 22:22:17 CDT