yoav112003 wrote:

> The performance is about the same as the original query. As in the
> original query, according to the plan the index on 'ROWID' in table
> 'events' is not used (natural sort is used), and if I try to specify
> it in a custom plan I get the error:
>
> SQL Message : -284
> index cannot be used in the specified plan
>
> How can I force FB to use this index?

With that query you can't. It uses what's in WHERE clause of subselect.

If you really want it, use JOIN.

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org


--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org