General information
Forum:
Microsoft SQL Server
Hi All,
I design my tables to have an "ID" column that is an "identity" value. I have set this as the primary key, since I do many lookups on the value.
I also may have a foreign key in the table that references the primary key of another table. When apprpriate, I have set this column to be "clustered" index because of the uniqueness of the values (less than 95%).
Is it OK to design my indexes like this?
Thanks in advance..
Michael
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only