The purpose of the code is: The last entry is considered the "current" entry and should be updated when the programm encounters e.g. a error. (Then the field error_count of the "current" entry is then incremented)
On Tue, Feb 4, 2020 at 12:40 PM Svein Erling Tysvær setys...@gmail.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > 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 >> >> >> >> >