Wednesday, December 4, 2019

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.

viastudy

Author & Editor

Has laoreet percipitur ad. Vide interesset in mei, no his legimus verterem. Et nostrum imperdiet appellantur usu, mnesarchum referrentur id vim.

0 comments:

Post a Comment