Raul Walter

to add, again @dyemanov select first 1 count (NF.NFS) as REGISTROS, NF.STATUS_NFE from NF_SAIDA NF join OPERACOES_FISCAIS OP on NF.EMPRESA = OP.EMPRESA and NF.OPF_CODIGO = OP.OPF_CODIGO where NF.EMPRESA = 1...

hello @dyemanov even if you remove from order by ('NOTA_FISCAL') , it hangs. another problem founded: **We have identified significant performance regressions in Firebird 5.0.3 compared to 3.0:** -- Same...

@dyemanov Hello, did you test it? Any news? What you think about it?

**Additional findings** I've performed several more tests with different databases and queries, and the behavior is consistent. After running SET STATISTICS or ALTER INDEX ... ACTIVE, the performance degradation is...

@mrotteveel Thank you for the clarification. Yes, I understand that changes in index statistics can lead the optimizer to choose different plans - that's expected. My specific concern is the...