FB 1.5 Classic on Windows.
Just wondering about the difference in speed in these 2 simple queries:

select max(field1) from table1

select max(field1) from table1 where field1 > 1000000

The second one being a lot faster.

The point is that this field has a unique ascending index, so if I do the
simple phonebook analogy why is it faster to look at the last entry in the
book or the last entry, but saying the name has to be > zaaa


RBS