Subject Re: Indexed used with search name='TEST' but not with name like 'TEST%'
Author swestner
I used both: the test-SQL and the real-world-sql.Both works fine.

Stefan

--- In firebird-support@yahoogroups.com, "Fidel Viegas"
<fidel.viegas@...> wrote:
>
> On Tue, Apr 29, 2008 at 12:11 AM, swestner <s@...> wrote:
>
> > Hello Sean,
> >
> > THANKS!!!!!
> >
> > Creating the Index IdxWordtest on word (attribute, data) did the
job.
> > Both queries runs in about 3-4 seconds.
> >
> > Many thanks!
>
> Hi Stefan,
>
> Did you use the original (or the generated) select statement? Or did
> you use the suggested ones?
>
> Fidel.
>