Skip to main content
Inspiring
September 30, 2011
Answered

Indexing Fields in SQL - PK & IX?

  • September 30, 2011
  • 1 reply
  • 973 views

When I set a field in MS SQL 2005 to primary key, it automatically creates a PK index in the INDEXS for that particular table. The question is, do I also need to create an IX index for it? It does allow it, but do I need it?

Thanks

Mark

This topic has been closed for replies.
Correct answer Dan_Bracuk

no

1 reply

Dan_BracukCorrect answer
Inspiring
September 30, 2011

no

ACS LLCAuthor
Inspiring
September 30, 2011

I had a feeling it was worthless, but thought it odd that SQL allowed me to do it.

Thanks

Mark