What is the difference between a clustered index and non clustered ind

1.	What is the difference between a clustered index and non clustered index ?
Answer» A clustered index is a form of index that reorders the PHYSICAL storage of records in a table, whereas a NON clustered index is one in which the logical order of the index does not match the physical storage order of the rows on the disc. Insert and UPDATE operations are FASTER than with a clustered index. Data is PHYSICALLY stored in index order, making it faster to read than non-clustered data.

Discussion