Hi

I suspect cardinality issue gather stats on that column with histograms and let us know what happens.

regards
Hrishy