Clustered Index
- describes the order wherein the records are physically stored
- only one per table
- faster to read as data is physically stored in index order
- to enhance insert & update, clustered indexes should be set on a field that is normally incremental i.e. Id or Timestamp
Non Clustered Index
- defines a logical order that does not match the physical order on disk
- can be used many times per table
- quicker for insert and update operations than a clustered index
- describes the order wherein the records are physically stored
- only one per table
- faster to read as data is physically stored in index order
- to enhance insert & update, clustered indexes should be set on a field that is normally incremental i.e. Id or Timestamp
Non Clustered Index
- defines a logical order that does not match the physical order on disk
- can be used many times per table
- quicker for insert and update operations than a clustered index
No comments :
Post a Comment