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