Archives: December 2010
Clustered index vs Non clustered index structure
Clustered and Non clustered indexes are stored in a B – tree structure .
- Clustered index enforce the logical order. (Misconception: Clustered index does not enforce the physical order)
- A table has only one clustered index because, the original table…