| Subject | Re: [firebird-support] Re: Indexed used with search name='TEST' but not with name like 'TEST%' |
|---|---|
| Author | Fidel Viegas |
| Post date | 2008-04-28T23:36:55Z |
On Tue, Apr 29, 2008 at 12:11 AM, swestner <s@...> wrote:
Did you use the original (or the generated) select statement? Or did
you use the suggested ones?
Fidel.
> Hello Sean,Hi Stefan,
>
> THANKS!!!!!
>
> Creating the Index IdxWordtest on word (attribute, data) did the job.
> Both queries runs in about 3-4 seconds.
>
> Many thanks!
Did you use the original (or the generated) select statement? Or did
you use the suggested ones?
Fidel.