sql sqlserver identity插入记录设置和 CLUSTERED | NONCLUSTERED 区别

 

ALTER TABLE [CheckOutType] WITH NOCHECK ADD  CONSTRAINT [PK_CheckOutType] PRIMARY KEY  NONCLUSTERED ( [ID] )
SET IDENTITY_INSERT [CheckOutType] ON

INSERT [CheckOutType] ([ID],[Code],[Name],[flag]) VALUES ( 1,'XJ','现金',0)

SET IDENTITY_INSERT [CheckOutType] OFF

 

 

CLUSTERED | NONCLUSTERED

    指定为 PRIMARY KEY 或 UNIQUE 约束创建聚集或非聚集索引。PRIMARY KEY 约束默认为 CLUSTERED；UNIQUE 约束默认为 NONCLUSTERED。

    如果表中已存在聚集约束或索引，那么在 ALTER TABLE 中就不能指定 CLUSTERED。如果表中已存在聚集约束或索引，PRIMARY KEY 约束默认为 NONCLUSTERED。

最大区别在于clustered是物理上实现数据排序，并且同一个表里只能有一个clustered索引，而nonclustered是逻辑上的排序。

There are clustered and nonclustered indexes. 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.

CLUSTERED | NONCLUSTERED    指定为 PRIMARY KEY 或 UNIQUE 约束创建聚集或非聚集索引。PRIMARY KEY 约束默认为 CLUSTERED；UNIQUE 约束默认为 NONCLUSTERED。
    如果表中已存在聚集约束或索引，那么在 ALTER TABLE 中就不能指定 CLUSTERED。如果表中已存在聚集约束或索引，PRIMARY KEY 约束默认为 NONCLUSTERED。
最大区别在于clustered是物理上实现数据排序，并且同一个表里只能有一个clustered索引，而nonclustered是逻辑上的排序。There are clustered and nonclustered indexes. 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.