• Yes.

    A table scan (only present when you don't have a clustered index) is a scan of the data pages of the table.

    An index scan reads the leaf pages of the index. If it's a nonclustered index, it'll be a lot fewer pages than the table.

    A clustered index scan (only present if there's a clustered index) reads the leaf pages of the clustered index, which are the data pages of the table. It's virtually the same same as a table scan. There are some minor differences as to how SQL does the scan, but it is the entire table, like with a table scan.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass