ower than currently?
>
> On 29 March 2017 at 11:58, Slavomir Skopalik <skopa...@elektlabs.cz> wrote:
>
>> Hi all,
>>
>> after discussion with Jiri Cincura I prepare proposal for prepared
>> statement cache that will be implemented inside .NET provider.
>>
statements.
The question:
Is this interesting to have this functionality inside provider and fully
transparent?
Slavek
PS: We combine this with RO transaction pool and also with data caching,
but this is different story.
--
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection
Hi,
the LIKE statement is very complex and in some cases it can used index.
.. WHERE aaa LIKE 'aaa%'
and in outher not:
... WHERE aaa LIKE '% aaa'
SP must create plan when you are preparing statament and this is before
sending parameters.
In second case, you run SQL on fly and in this case the