| Subject | RE: [firebird-support] Speed of comparing one field to another |
|---|---|
| Author | Maya Opperman |
| Post date | 2016-10-05T08:42:54Z |
>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