Hello Sean,

THANKS!!!!!

Creating the Index IdxWordtest on word (attribute, data) did the job.
Both queries runs in about 3-4 seconds.

Many thanks!

Stefan


--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...>
wrote:

>
> Stefan,
>
> > Plan:
> > PLAN JOIN (IWADISOBJE_1 INDEX (IDXIWADISOBJECT1), WORD_1 INDEX
> > (IDXWORD3))
> >
> > Prepare time: 1 ms
> > Execution time: 490640 ms
> > Fetch time: 2319 ms
> >
> >
> > - how many entries are in the entire IwadisObject table
> > 77225
> > - how many entries have IwadisObject BOLD_TYPE IN (122)
> > 52281
> > - how many entries are in the whole Word table
> > 9666470
> > - how many Word table entries have Word_1.attribute = 'NAME'
> > 332000
> > - how many Word table entries have Word_1.data LIKE 'ANFRAGE%'
> > 1715
> > - how many Word table entries have Word_1.attribute = 'NAME' *AND*
> > Word_1.data LIKE 'ANFRAGE%'
> > 295
>
> Please create a new compound index based on Word_1.attribute and
> Word_1.data (in that order) (or is IXWORD3 that index?).
>
>
> Sean
>