Hello. Try using a "WHERE" clause if possible. Ex: WHERE "some_date_column_of_the_table" > (current_date - n)
Atenciosamente, + + Hugo Eyng + + ________________________________ De: [email protected] <[email protected]> em nome de Matthias Winkler [email protected] [firebird-support] <[email protected]> Enviado: terça-feira, 4 de fevereiro de 2020 11:36 Para: [email protected] <[email protected]> Assunto: [firebird-support] Bad performance with select first(1) + order by 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
