Home Forums SQL Server 2008 SQL Server 2008 - General Want to Convert PRIMARY KEY from NONCLUSTERED TO CLUSTERED pls Advice !! RE: Want to Convert PRIMARY KEY from NONCLUSTERED TO CLUSTERED pls Advice !!

  • July 8, 2014 at 6:17 am

    #1727737

    Koen Verbeeck (7/8/2014)

    Hardy21 (7/8/2014)

    The clustered index has an advantage over all other indexes: since it always includes all columns, is always covering. Therefore queries that can leverage the clustered index certainly do not need to use lookups to satisfy some of the projected columns and/or predicates.

    Yes, but if queries cannot leverage the clustered index, you are still doing a full table scan.

    Thats is correct. It depends on how you query the data.

    Thanks