> 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

To speed up MAX, you need a DESCENDING index.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/