• They are PK indexes, so they are clustered.

    A primary key does not have to be a clustered index.

    A clustered index does not have to be the primary key.

    When you create a primary key using the GUI in SQL Server, it automatically makes it clustered (I think?).

    This may or may not be the best use of the clustered index, your mileage may vary.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/