NON CLUSTERED ON PRIMARY KEY

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 379
SQL Server allows us to create NONCLUSTERED INDEX on Primary Key Column.... by default its CLUSTERED INDEX unless we specify NONCLUSTERED keyword while creation...


Sample code,

CREATE NONCLUSTERED INDEX  IX_NONCLUSTERED_PRIMARY ON TableName(PK_ColumnName)

Comments or Responses

Login to post response