On 3/24/08, Slavomir Skopalik <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
> this is because LIKE operator in general case CAN'T use a index.
> You must equal or other operator instead.
>
> Slavek
>
> PS: Like in this case is dangerou because huge performance penalty
> (try use second case with SuchName='%').
Hi Slavek,
isn't the problem on other side?
AFAIU the problem, the first procedure (without exec stmt) runs very
slowly and the second (same statement, but only executed thru exec
stmt) runs fast. Or did I miss something?
BTW We're little bit OT in this list.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
