Subscribe to this blog
SQL Server Blog Forum
My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.
Archives: December 2010
Clustered index vs Non clustered index
Clustered index vs Non clustered index structure
Clustered and Non clustered indexes are stored in a B – tree structure .
Clustered Index
- 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…
6 comments, 784 reads
Posted in SQL Server Blog Forum on 2 December 2010