Post reply

Clus Constraint v Clus Index

  • June 30, 2006 at 8:49 am

    #173141

    I note that a developer I employed has tended to create clustered constraints on my database rather than clustered indexes.

    Is there a difference in performance?  Is there a difference of any kind, in practice?

     

    Thanks

     

    Kenny

  • June 30, 2006 at 10:45 am

    #647032

    Physically, there is no difference between the two. A clustered constraint is physically implemented as a clustered index.

    A Constraint is a logical concept, and the index structure is simply a way of making it physical.

    If the clustered constraint is a primary key constraint, then the optimizer will treat this slightly differently to an ordinary clustered index since no NULL values are allowed and uniqueness is guaranteed.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply