difference between a clustered and non-clustered database?

Question

difference between a clustered and non-clustered database?

Answer 1

I guess this is u r looking for..



A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.



A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Answer 2

Clustered data base has too many record in some portions, and have too many free indices in other portions. an inefficient hashing function can be the result of a clustered data base. Imagine a data base with a 1000 spots which has most records conentrated around indices 200 and 100, and rest of the database is just empty: it is a clustered data base.

Answer 3

A clustered system is split across serveral separate machines (physical or virtual). This approach improves ones ability to handle a lot of select-type transactions because of the ability to spead the load across the system. Inserts, updates, and deletes can have some added overhead due to the need to synchronize the data on each system.