|Subject||RE: [firebird-support] Speed of comparing one field to another|
>You could create a denormalized field that contains the difference of those values (updated by a trigger, perhaps), and you can put
>an index on that new field. Then change the query to find rows where [new difference field] < 0.
Thank you, looks like I will need to go that route