Subject Re: [firebird-support] Speed of comparing one field to another
Author Louis Kleiman
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?

On Tue, Sep 13, 2016 at 9:37 AM Dimitry Sibiryakov sd@... [firebird-support] <> wrote:
13.09.2016 15:26, Maya Opperman maya@... [firebird-support] wrote:
> Is there an index I could create to speed up the loading?


   WBR, SD.




Visit and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at


Yahoo Groups Links

<*> To visit your group on the web, go to:

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to: