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.