Subject Speed of comparing one field to another
Author Maya Opperman



I have a large table, and I’m only extracting a few records using:


Select t.ID

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