What is the difference between SQL Server 2000 clustered and nonclustered indexes?
With a clustered index, the data are kept in the bottom level of the index and in the similar order as that index. With a nonclustered index, the bottom level of an index does not have data; it contains pointers to the data. For data retrieval, clustered indexes are quicker than nonclustered indexes.