'Like' clause causes long execution - but only in ProC

Hello all,

I have two queries, in 1st there is condition >>column = 'value'<<, while in 2nd there is condition >>column like 'value%'<< - this is the only diffrence between them.
Time of execution in sqlplus is the same for both (less then 1s). Explain plans are identical for both.

And now the mystery: when these queries are executed in ProC executable, the second one (that with 'like') waits several seconds at OPEN CURSOR statement. I have no idea why.

Any ideas? Received on Tue Apr 06 2004 - 05:24:32 CDT