• Great question. And explanation.

    I should have thought about this for longer before picking an answer at random. I might have realised that an ORDER BY clause that specifies something other than the order of the only index that covers the query might choose to use an allocation order scan of the index provided nothing changed during the scan.

    Tom