Create descending index on table.field1.

Ivan

----- Original Message -----
From: "jasajona" <jon@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, July 27, 2004 3:43 PM
Subject: [firebird-support] Simple question


Hello,

Is it possible to optimize this query:

select
field2
from
table
where
field1 = ( select max(field1) from table )