Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


What are the two types of indexes and explain them in detail? or What’s the difference between clustered and non-clustered indexes?


 
There are basically two types of indexes:- 
Clustered Indexes.
Non-Clustered Indexes.
In clustered index the non-leaf level actually points to the actual data.In Non-Clustered index the leaf nodes point to pointers (they are rowid’s) which then point to actual data.

asked Sep 13, 2013 in Database(DBMS) by rajesh
edited Sep 12, 2013
0 votes
46 views



Related Hot Questions



Government Jobs Opening


...