Hello, With Firebird 2.1.7 this statement freezes my firebird server completely. Firebird will take 100% CPU.
select first(8) ID from TBL_TEST where ID not in (select first(2) ID from TBL_TEST order by ID desc) order by ID desc The used table has about 18`000 entries. If I remove ONE of the order statements the query runs fine and takes around 3s. Can somebody explain what execution plan is made for this statement and why it might sent my server into 100% CPU? Note: The statement here is simplified from my real usecase. The statement itself might not look useful. But that is not the point. *best regards* *Matthias *