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

點閱: 111

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

About the Author

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *

Related Posts