[firebird-support] Speed of comparing one field to another

[Maya Opperman m...@omniaccounts.co.za [firebird-support]]

Hi,

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
Maya