Saved Bookmarks
| 1. |
What is the difference between SQL Server 2000 clustered and nonclustered indexes? |
|
Answer» With a clustered index, the data are stored in the bottom level of the index and in the same order as that index. With a non clustered index, the bottom level of an index does not contain data; it contains pointers to the data. For data retrieval, clustered indexes are faster than non clustered indexes. |
|