SqlServer 相关术语

筛选索引

CREATE NONCLUSTERED INDEX FIBillOfMaterialsWithEndDate

ON Production.BillOfMaterials (ComponentID, StartDate)

WHERE EndDate IS NOT NULL

列集

CREATE TABLE DocumentStoreWithColumnSet

(DocID int PRIMARY KEY,Title varchar(200) NOT NULL,

ProductionSpecification varchar(20) SPARSE NULL,

ProductionLocation smallint SPARSE NULL,

MarketingSurveyGroup varchar(20) SPARSE NULL,MarketingProgramID int SPARSE NULL,

SpecialPurposeColumns XML COLUMN_SET FOR ALL_SPARSE_COLUMNS)

INSERT DocumentStoreWithColumnSet (DocID, Title, SpecialPurposeColumns)VALUES

(3, 'Tire Spec 2', '<ProductionSpecification>AXW9R411</ProductionSpecification><ProductionLocation>38</ProductionLocation>')

GO

稀疏列

CREATE TABLE dbo.DocumentStore

(DocID int PRIMARY KEY,Title varchar(200) NOT NULL,

ProductionSpecification varchar(20) SPARSE NULL,

ProductionLocation smallint SPARSE NULL,

MarketingSurveyGroup varchar(20) SPARSE NULL )

计算列（列集与计算列的相似之处在于，列集并不是物理地存储在表中。 列集与计算列的不同之处在于，列集可直接更新）

带有包含列的索引

CREATE NONCLUSTERED INDEX IX_Address_PostalCode ON Person.Address (PostalCode)

INCLUDE (AddressLine1, AddressLine2, City, StateProvinceID);