19 November 2013

Cluster vs NON-Cluster Index

Cluster vs NON-Cluster Index
1data 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.
2ReadFaster to read than NON-Cluster
3StorePhysically, Store Index Order
4Faster Insert/UpdateQucikly Insert and Update Data than a Cluster Index.
5TableOnly One Per Tablecan be used many time per Table
6OrderData is in Physical OrderLogical Order

No comments: