Disadvantages of Clustered Index

Here, are cons/drawbacks of using clustered index:
  • Lots of inserts in non-sequential order
  • A clustered index creates lots of constant page splits, which includes data page as well as index pages.
  • Extra work for SQL for inserts, updates, and deletes.
  • A clustered index takes longer time to update records when the fields in the clustered index are changed.
  • The leaf nodes mostly contain data pages in the clustered index.

No comments:

Post a Comment