2 Replies Latest reply: Jul 20, 2014 3:52 AM by Martin Preiss Branched from an earlier discussion. RSS

    Re: improve query performance

    Martin Preiss

      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.