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.

SanjayAttray (10/26/2009)

---

"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?

Sure, hard drives are cheap and storage is abundant but increasing the size of a database has other effects,

Carleton (10/26/2009)

---

I agree, excellent article Gail. I'll also be looking for the follow-up articles. -Carleton

SQL Noob (10/26/2009)

---

is there any hard documentation on what the tipping point is for an index seek to become an index scan? is it 5% of rows affected, 10% or some other percentage?