Comments posted to this topic are about the item Index Scan: Ordered or not?
This was removed by the editor as SPAM
As usual very informative question from Hugo, Thanx 🙂
Great question Hugo. Thanks for sharing
Learned something new from this one, so thank you.
One Orange Chip
Great question Hugo & informative answers, cheers.
Great question Hugo, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Viewing 9 posts - 1 through 8 (of 8 total)