is primary key compulsary in clustering?

• vnj

  SSC-Addicted

  Points: 439

  More actions

  January 13, 2012 at 1:28 am

  #249606

  Can we fing clusters of following data?

  Id P1 P2

  x 5.6 4.5

  x 1.6 4.5

  y 5.6 4.5

  having 2 clusters?

• azdzn

  SSCarpal Tunnel

  Points: 4128

  More actions

  January 13, 2012 at 1:45 am

  #1433058

  - your primary key hasn't to be your clustered index

  - only one clustered index per table.

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  January 16, 2012 at 9:10 am

  #1434126

  vnj (1/13/2012)

  ---

  Can we fing clusters of following data?

  Id P1 P2

  x 5.6 4.5

  x 1.6 4.5

  y 5.6 4.5

  having 2 clusters?

  I think original poster is referring to "clusters" on its data mining meaning, as in "data clustering" as opposed to "clustered/non-clustered indexes".

  Having said that, PKs are created to enforce uniqueness on a column or combination of columns, more related to referential integrity than to data mining - you can do "data clustering" in an indexless, PKless table.

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.