Wednesday, December 4, 2019

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.

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