Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> immediate value vs bind variable
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 addressReceived on Tue Jul 16 2002 - 16:11:13 CDT
![]() |
![]() |