Erik Darling shows us a scenario in which sort direction on an index matters:
I got a mailbag question recently about some advice that floats freely around the internet regarding indexing for windowing functions.
But even after following all the best advice that Google could find, their query was still behaving poorly.
Why, why why?
Eric explains how, how, how.