Hits: 217
1-10. Cluster index
- Index can be best described as a pointer to data in a table.
- Use index for retrive data efficiently and fast
- type
- clustered index
- sort the data rows in the table based on their key values
- doesn’t not require disk space
- index建好之後,新增的資料都會依照index自動排序
- nonclustered index
- disk space will increase.
- compositie index
- others
- clustered index
Comments