Clustered indexes affect the way data is physically stored on the disk
by the DBMS. That's why you can only have one per table. I suspect that
since primary keys are "usually" the most used column for joining, you
want accesses to those rows to be super fast, hence you want the data
to be laid out on disk to facilitate that, hence the clustered index.
T
Posts made by tokk
-
RE: Primary Key/Clustered Index