Disadvantages of Non-clustered index


Here, are cons/drawbacks of using non-clustered index:
  • A non-clustered index helps you to stores data in a logical order but does not allow to sort data rows physically.
  • Lookup process on non-clustered index becomes costly.
  • Every time the clustering key is updated, a corresponding update is required on the non-clustered index as it stores the clustering key.

No comments:

Post a Comment