Saturday, December 17, 2011

Compare Clustered and Non-Clustered Index

 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