| S.No | Particulars | Cluster | NON-Cluster |
|---|---|---|---|
| 1 | data rows | sort and store the data rows in the table or view based on their key values. | have a structure separate from the data rows. |
| 2 | Read | Faster to read than NON-Cluster | |
| 3 | Store | Physically, Store Index Order | |
| 4 | Faster Insert/Update | Qucikly Insert and Update Data than a Cluster Index. | |
| 5 | Table | Only One Per Table | can be used many time per Table |
| 6 | Order | Data is in Physical Order | Logical Order |
Upload My Experience and Learning
No comments:
Post a Comment