Looking to Build/Redesign a Website or Blog ?

To speak to Rakshit, call +91 968 704 2303

January 7, 2011

4 Comments

mysql-database-freelancer-developer-2

Differance between Clustered indexes Vs Non-clustered indexes

A clustered index is a special type of index that reorders the records in the table are physically stored. In non-technical way, you are telling the database to store close values to one another on the disk. This means, a table can have only one clustered index. This has the benefit of rapid scan / retrieval of records on any operation with clustered index values.