Home Forums Data Warehousing Strategies and Ideas create a table with two primary keys. RE: create a table with two primary keys.

  • February 20, 2014 at 3:12 am

    #1690583

    azhar.iqbal499 (2/20/2014)

    Actually, when we define primary key on a table, data is stored in the physical order of primary key

    Not true.

    The clustered index (not primary key) enforces the logical storage order of the data. It does not enforce the physical storage order however.

    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