SQL Server 2000 clustered indexes and non clustered indexes

Question

Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?

Answer 1

In a clustered index, the data are stored in the bottom stage of the index and in the same order as that index. In a non clustered index, the bottom stage of an index does not contain data; it contains pointers to the data. For data retrieval, non clustered indexes are slower than clustered indexes.