Northwind Database (Document! X Sample)
IX_Customer_TerritoryID Index
AdventureWorks Database > Sales Schema > Sales.Customer Table : IX_Customer_TerritoryID Index
Description
Nonclustered index.
Properties
File GroupPRIMARY
Space Used296.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
 ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.Ascending
Index Statistics
Average key length8.00
Density0.00
Rows in the Table19820
Rows Sampled19820
Distribution Steps10
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

Sales.Customer Table
Sales Schema
AdventureWorks Database