• 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.

    SQL DBA.