|Subject||Speed of comparing one field to another|
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