Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 'Like' clause causes long execution - but only in ProC

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

From: MariuszR <rustek2_at_poczta.onet.pl>
Date: Tue, 6 Apr 2004 12:24:32 +0200
Message-ID: <c4u0ie$1bku$1@news2.ipartners.pl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US