This content has been marked as final. Show 2 replies
which data type is used for in_fulfill_state? Given the selectivity of this column an index access could be efficient (though it also depends on the physical distribution of rows in the data blocks). If in_fulfill_state is of type number you could try to add an index hint to force the use of index PSSIN_DEMAND. If (and only if) the index has a positive impact then the next step would be to try to find out why the optimizer does not consider it without a hint.