Checking whether the join cardinality estimates are accurate
should only be done when the order by limit optimization is
enabled.