Why should only one clustered index be created in a sql server for a table?

Question

I read SQL Server database tips at http://www.sql-server-performance.com/2007/clustered-indexes

In the final section, the author mentioned: "Since you can only create one clustered index for each table, take the extra time to carefully consider how it will be used."

My question is:

* Why only one clustered index for a table should be created on sql server? *

Answer 1

: . , . , .

? , , sql - . .

. .

Answer 2

- , , . , .

- .

Answer 3

SQL Server. , . MongoDB MyISAM . InnoDB MySQL , , , . TokuDB MySQL TokuMX ( ) , - , .

Answer 4

. , .

, Create as Clustered .

Answer 5

! ()

, . , .

Answer 6

The clustered index defines the physical order of the data in the table as the home address, so we should only have one home address, if not the postman gets confused.

http://msdn.microsoft.com/en-us/library/aa933131.aspx