what will be right way to deal with this query

maybe a stupid suggestion but do you created well the statistics? try to use both:
analze table x estimate statistics;
analze table x estimate statistics for all indexes;

tell us buffer gets per executions and not the cumulative buffer gets