Just create a descending index, Set tir. 4. feb. 2020 kl. 12:36 skrev Matthias Winkler spmm...@gmail.com [firebird-support] <firebird-support@yahoogroups.com>:
> > > Hello, > > I am struggling with my DB performance once more: > > SELECT FIRST(1) PRIMKEY > FROM TABLE_X > ORDER BY PRIMKEY DESC > > The statement is slow once more because of the sorting. > I just want to find the entry with the highest primary key. > The PRIMKEY is ASC and unique. > > Is the another way to achieve the same? > > Thanks > > Matthias > > > >