> are unique and only one in a row. It is physically sorted index.
> clustered are the one which will not be changed often.
> 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.