• Sergiy (7/16/2014)


    Koen Verbeeck (7/16/2014)


    So it is 100% possible to decouple the primary key from the index

    Can you illustrate how?

    Easy peasy. I draw a table diagram in Visio and declare the combination of a few columns to be the primary key.

    (in other words, I am creating the logical design)

    Where do you see an index?

    The index we are talking about is the manifistation of the primary key on the physical level.

    On the logical level however, I simply do not care how it is implemented at the physical level. It does not matter.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP