On 20-10-2017 05:45, gn7soft@... [firebird-support] wrote:

> I'm going to develop a commercial program with Firebird2.1, in Delphi7.
> I want to know whether the following index is picked by the optimizer.

You do realise that Firebird 2.1 is no longer supported and hasn't
received updates (including security fixes) since December 2014. Using
that version for a program you are developing now is doing yourself and
your users a disservice IMHO.

You should be targeting Firebird 3 (maybe 2.5).

Mark
--
Mark Rotteveel