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
tokk
@tokk
0
Reputation
1
Posts
19
Profile views
0
Followers
0
Following
Best posts made by tokk
This user hasn't posted anything yet.
Latest posts made by tokk
-
RE: Primary Key/Clustered Index