What Is The Difference Between Sql Server 2000 Clustered And Nonclust

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 nonclustered 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 nonclustered indexes. 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 nonclustered 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 nonclustered indexes.

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 nonclustered 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 nonclustered indexes.

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 nonclustered 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 nonclustered indexes.

Discussion

No Comment Found

Related InterviewSolutions

What Is Lock Granularity?
In General, How Should The Boundaries Of A Transaction Be Defined?
Explain The Meaning Of The Expression Acid Transaction?
Explain The Necessity Of Defining Processing Rights And Responsibilities. How Are Such Responsibilities Enforced?
Explain How A Database Could Be Recovered Via Reprocessing. Why Is This Generally Not Feasible?
Define Rollback And Roll Forward?
Why Is It Important To Write To The Log Before Changing The Database Values?
Explain The Difference Between A Database Administrator And A Data Administrator?
What Is The Foreign Key?
What Is A Candidate Key?