Subject | Re: Indexed used with search name='TEST' but not with name like 'TEST%' |
---|---|
Author | swestner |
Post date | 2008-04-30T18:55:45Z |
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:
Stefan
--- In firebird-support@yahoogroups.com, "Fidel Viegas"
<fidel.viegas@...> wrote:
>job.
> 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
> > 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.
>