Hi all - basic question here I think.

If I have a table that has no Primary Key defined but has a non clustered
index on the Id field, will it perform better or worse if it had a Primary
Key field with a clustered index on the Id field? Say the table had a
million rows in it.

I'm looking for the best performance. I always understood that it was
better to have a PK on a table. Thats like Rule 101 of DBA class right?

Thanks!


MS Sql Server LazyDBA home page