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.