Home Forums SQL Server 2005 Administering Covering Index Question RE: Covering Index Question
durai nagarajan
SSCoach
Points: 15775
More actions
July 26, 2013 at 8:48 am
#1636195
patientnumber looks unique keep this a primary key and create non clustered index as per requirement.
covering index column will work faster than columns not in any columns.
RegardsDurai Nagarajan