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