Re: identity, plus pk?

>>From a strict performance perspective, the presence or absence of keys
has no real effect, especially given the fact that you've managed to
collect 3.5 million records of data without relational constraints.

Your consultant probably meant to encourage you to build a unique
clustered index, which is built by default when you add a primary key
constraint. However, they are not the same; a clustered unique index
can exist without a primary key, and a primary key need not be
clustered (it must, however, be unique). Check the Books OnLine for
clustered indexes, or visit www.sql-server-performance.com for more
help with indexes.

Stu

.

Relevant Pages

  • Clustered Indexes / Primary Key
    ... The first thing I have run into is Clustered Indexes not sorted. ... The Cat. ... No. is the Primary Key, Clustered, Unique, No-Nulls. ... Just learning SQL Server. ...
    (microsoft.public.sqlserver.odbc)
  • Re: index
    ... Most of the DB clustered indexes I've had experience using/ ... creating etc have all been primary keys using an identity field on an ... I presume this might be if you have identity inserts allowed? ... presuming a Primary Key would also fill the role of the unique keyword ...
    (microsoft.public.sqlserver.programming)
  • Re: Autonumber Fields
    ... I don't recall talking about clustered indexes at all. ... believe that a clustered index is a requirement for a primary key. ... Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.tablesdbdesign)