Re: Autonumber Fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

CORRECTION:

I don't. I don't recall talking about clustered indexes at all. I also DO
NOT
believe that a clustered index is a requirement for a primary key.
Certainly, EF Codd said nothing about it. This is an implementation issue,
not a design issue.


--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L



.

Relevant Pages

  • Re: Another Cluster Index Question?
    ... A clustered index on the customers table on the lname column would ... be a poor choice. ... Clustered indexes on columns that are frquently used in ... > table's Primary key being made a Clustered Index by default. ...
    (microsoft.public.sqlserver.programming)
  • Re: index
    ... It is my understanding that a table is the physical analog of a ... you're ignoring the fact that a clustered index ... obtains a lock on a row in ci#1 and then attempts to obtain a lock on ... one of the clustered indexes can be designated as primary as far ...
    (comp.databases.theory)
  • Re: index
    ... Theoretically, one can have multiple clustered indexes at the cost of duplicating the data, which of course incurs a cost. ... A table that does not have a clustered index, on the other hand, is physically stored as a heap. ... Although it is possible to have multiple indexes that cover the entire heading, that is not the same thing as having multiple clustered indexes. ...
    (comp.databases.theory)
  • 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
    ... which of course incurs a cost. ... You can't have two clustered indexes ... you're ignoring the fact that a clustered index /is/ a ... obtains a lock on a row in ci#1 and then attempts to obtain a lock on the ...
    (comp.databases.theory)