Monday, May 11, 2015

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 Smile

MVC Articles & WCF and WebAPI

Thanks for reading Smile


Post a Comment