SanjayAttray (10/26/2009)

---

Thanks for the article, Gail.

"When an index scan is done on the clustered index, it’s a table scan in all but name."

Then why do we see index scan and table scan separately in execution plan rather just table scan on a single query with simple join?

Would wait for part 2 and 3.