November 8, 2015 at 10:28 pm
Comments posted to this topic are about the item Index Scan: Ordered or not?
November 8, 2015 at 10:29 pm
This was removed by the editor as SPAM
November 9, 2015 at 10:34 pm
As usual very informative question from Hugo, Thanx 🙂
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
November 10, 2015 at 1:01 am
Great question Hugo. Thanks for sharing
November 10, 2015 at 6:16 am
Learned something new from this one, so thank you.
November 10, 2015 at 6:45 am
Great explanation.
November 10, 2015 at 7:57 am
Great question Hugo & informative answers, cheers.
November 12, 2015 at 1:54 am
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
January 19, 2016 at 4:52 am
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply