> You might want to add indices on the columns STATUS,
> HANDLED_TIMESTAMP and RECEIPT_TIMESTAMP

An index on HANDLED_TIMESTAMP will not help, in this case since indexes are never used in resolving IS NOT NULL conditions.

Further, depending on the selectivity of values a compound index on STATUS + RECEIPT_TIMESTAMP (in that order) is likely to be better than separate indexes for the columns.


Sean