Because we have a query which used Nested Loops if we have RANGE_ROWS and then the query performes worse.

But we can't change the query at the moment, that is the problem