psingla (7/9/2013)
If this is special case of clustered index scan then that means clustered index scan and index order scan both should be the answer...
No.
It's asking for the specific name of the type of scan done when a clustered index is scanned in index logical order. Answering 'clustered index scan' cannot be the correct answer because that's not a specific name that involves the scan ordering.
It's not a special case of a clustered index scan, it's one of the two ways that a clustered index scan can be done.
You can kinda tell and I'm sure there's a few hits on a google search that will discuss it in more detail.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability