Home > IT Answers > SQL Server > Including a primary key in a nonclustered index in SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Including a primary key in a nonclustered index in SQL Server 2005
Index, Primary keys, SQL performance, SQL Server 2005
The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase SQL performance?

Software/Hardware used:
ASKED: July 2, 2008  5:36 PM
UPDATED: July 2, 2008  8:01 PM
RELATED QUESTIONS
Answer Wiki:
Yes, it is perfectly fine to include the primary key as a column within an index.
Last Wiki Answer Submitted:  July 2, 2008  8:01 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.