Primary index and Secondary index In Sql Server

Primary index and Secondary index In SQL Server

Primary index:

• A primary index is an index on a set of fields that includes the unique primary key for the field and is guaranteed not to contain duplicates.
• This also called as Clustered index.
• e.g. ID  in Employee can be an example of this.

Secondary index:

• A Secondary index is an index which is not a primary index and it may have duplicates values.
• e.g. First_name can be example of it. Because First_name name can have similar values like “james”.

These may be helpful down the line .Enjoy Coding and Smile 

MVC Articles & WCF and WebAPI

Thanks for reading

Categories: SQL Server