Observation: Possible Non-indexable BETWEEN
You coded a BETWEEN predicate that may be non-indexable. The BETWEEN predicate must be in one of the two following forms to be indexable:
<column> BETWEEN <value> and <value>
or
<column> BETWEEN < noncol expr> and < noncol expr>
Where:
-
<value> is one of the following: constant, host variable, or Special Register.
-
< noncol expr> is any expression, including functions, that does not reference a column.