What are the types of index.

=> There are two type of index.

1. Clustered Index :-
        Clustered index physically rearrange the data that user inserts in your tables. It is nothing but a dictionary type data where actual data remains.
In one table only one clustered index is stored.

2. Non clustered Index :- 
         Non clustered index contains pointers to the data that is stored in the data page. It is a kind of index backside of the book where you see only the reference of a kind of data.

Share

& Comment

Tweet