What is key and non-key column wrt to indexes

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  December 11, 2012 at 4:24 am

  #393779

  Hi,

  Since this might be the most basic question hence i did not find its answer anywhere. Could anybody tell me what is mean by Key & Non-Key column with respect to indexes.

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  December 11, 2012 at 4:27 am

  #1567360

  A key column is the column(s) that the index is created on, the non-key column are included columns

  CREATE NONCLUSTERED INDEX idx1 ON Table1 (Col1, Col2) INCLUDE (Col3, Col4)

  In the above example, Col1 and Col2 are key columns, Col3 and Col4 are non-key columns

  CREATE CLUSTERED INDEX cidx ON Table1 (Col1)

  In the above example Col1 is the key column, and all other columns in the table are classed as non-key columns, as the clustered index is the table.