Subject RE: [firebird-support] Speed of comparing one field to another
Author Maya Opperman

>Loius Wrote:

>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.


>Make sense?


Thank you, looks like I will need to go that route