Creating indexes on other keys

• iccEC

  SSC Rookie

  Points: 30

  More actions

  August 5, 2005 at 7:53 am

  #89332

  Hi all,

   

  I've read in many "tuning" articles that it is best to create indexes on Foreign keys to gain performance.

   

  With that information, I was wondering if I should/ or have to do the same on PRIMARY or UNIQUE keys if they are not clustered ??

   

  Thanks in advance,

  Eric CREPEAU

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  August 5, 2005 at 8:08 am

  #580014

  Both primary keys and unique constraints are enforced by SQL Server with a unique index, so there is no need to create it yourself.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• iccEC

  SSC Rookie

  Points: 30

  More actions

  August 8, 2005 at 8:29 am

  #580443

  Thanks Chris!

   

  Eric CREPEAU