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 [email protected] [firebird-support] <[email protected]> wrote: > 13.09.2016 15:26, Maya Opperman [email protected] > [firebird-support] wrote: > > Is there an index I could create to speed up the loading? > > No. > > > -- > WBR, SD. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org 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 > http://www.ibphoenix.com/resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > >
