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