Sudeep Biswas

• Nov 16th, 2006

 

In order to understand wht is a clustered index in oracle it is imp. to know what is a cluster. A cluster is a method to store data for more than 1 table in the same block.This can be compared to a condition where we have a join condtion of 2 tables(primary key of one is the foreign key in other). Under such conditions, we need to index the cluster i.e. which data segment belongs to which table. Such type of clustering is Indexed clusetering in oracle.Plz make a note that clustered index has some other meaning in other data base esp. Sybase.