Advantages of Non-clustered index

Pros of using non-clustered index are:
  • A non-clustering index helps you to retrieves data quickly from the database table.
  • Helps you to avoid the overhead cost associated with the clustered index
  • A table may have multiple non-clustered indexes in RDBMS. So, it can be used to create more than one index.

No comments:

Post a Comment