--- In firebird-support@yahoogroups.com, Neil wrote:

> Thanks Helen - that worked fine. Problem now is getting an
> intersection between 24000 hits and 33000 hits takes ages. But
> that's a data issue.

It could also be an issue with the your indexes. 24000 and 33000
doesn't sound like all too many. I'd say a plan like
PLAN SORT(A1 INDEX(WordIndex), A2 INDEX
(LineParagraphChapterSectionIndex))

(or something similar, this PC doesn't have Firebird and I don't know
your tables) shouldn't be too slow. Maybe you could observe an
improvement by changing to a2.WORD||''='LEFT'.

Set