Subject Re: Query runs 9 minutes - how to set indexes to optimize it
Author swestner
Hello Paul,

I use Firebird 2.1.1

Using "starting" makres no difference...

Stefan

--- In firebird-support@yahoogroups.com, "Mercea Paul"
<paul.mercea@...> wrote:
>
> Hi
>
> I don't see what version of FB are you using.but:
>
>
>
> Instead Word_1.data LIKE 'SCHAAF%' I would use Word_1.data STARTING
with
> 'SCHAAF'
>
>
>
> Regards,