Containing is not case sensitive and cannot use an index. But it could not be
indexed anyway because thestring could occur anywhere in the field, not just at
the start. Starting (or is it starts?) is case sensitive and equivalent to
like% so it can use an index.
Good luck,
Ann
On Aug 4,
Mark,
thanks for your answer. (the page number I mentioned was on the first
edition ).
Aldo Caruso
El 04/08/14 a las 11:50, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escibiĆ³:
On 4-8-2014 16:42, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
Hello,
Hello,
I have three questions relating CONTAINING predicate.
In The Firebird Book I read on page 318 that indexes are used
also on search conditions against CONTAING predicates. I did some test
and, inspecting its PLAN, I found that it uses NATURAL order instead of
using an index.
On 4-8-2014 16:42, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
Hello,
I have three questions relating CONTAINING predicate.
In The Firebird Book I read on page 318 that indexes are used
also on search conditions against CONTAING predicates. I did some test