clustered index
> are unique and only one in a row. It is physically sorted index.
> clustered are the one which will not be changed often.
Non-clustered index
> logical sorted index
> is logically stored a table can have 249 non clustred index.Non clustered index will be created automatically when u
create unique key on a column.
List of Asked Interview Questions: C# .NET SQL MVC WCF Questions