Subject RE: [firebird-support] Question about using Indexes (long post)
Author Leyne, Sean

> I have a procedure that is using an index in one select statement, but
> the another identical one....

Based on my visual review, there is no obvious reason for the difference
-- so you're not going crazy. ;-)

But let me point out, that you are using the same table aliases for the
2 statements -- I generally only use an alias once in an SP (just my own
little 'standard').

What happens if you change the aliases in the 2nd statement?