|Subject||Re: [firebird-support] Speed of comparing one field to another|
|Author||Walter R. Ojeda Valiente|
On Tue, Sep 13, 2016 at 9:26 AM, Maya Opperman maya@... [firebird-support] <email@example.com> wrote:
I have a large table, and I’m only extracting a few records using:
From my_table t
Where t.Invoiced < t.Received
Invoice and received are of type decimal(18,5)
IBExpert is reporting these as unindexed reads.
Is there an index I could create to speed up the loading?
Thanks in advance