CLUSTURED INDEX AND NON CLUSTURED INDEX DIFFERENCES IN SQL SERVER 2005

1. Data is physically sorted in clustured indexes and in case of non clustured indexes data is logically sorted.

2. We can create maximum of 1 clustured index on a table in sql
server 2005. In case of non clustured index we can create maximum of
249 indexes on a table in sql server 2005.

3. The leaf page of the clustured index contains entire data. The
leaf page of non clustured index does not contain entire data. It will
provide book mark look up.( FILE NO | Page NO | ROW NO )

Share Knowledge.We all are here to learn.

Pawan Kumar

Pawankkmr@hotmail.com

Advertisements