[Udemy] 課堂筆記 – SQL Server Administration Part 2

Visits: 0

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

1-11. Create non cluster index