Use parallel scan for limit with no order by.