It still scans the index, but it doesn't fetch those rows that will be discarded. After it reaches the right page, it fetches the rows themselves. So it doesn'

It still scans the index, but it doesn't fetch those rows that will be discarded. After it reaches the right page, it fetches the rows themselves. So it doesn't exactly avoid the wall, but it can push it considerably further away.