Northwind Database (Document! X Sample)
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate Index
AdventureWorks Database > Sales Schema > Sales.SalesPersonQuotaHistory Table : PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used16.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeySales person identification number. Foreign key to SalesPerson.BusinessEntityID.Ascending
Primary KeySales quota date.Ascending
Index Statistics
Average key length12.00
Density0.10
Rows in the Table163
Rows Sampled163
Distribution Steps11
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

Sales.SalesPersonQuotaHistory Table
Sales Schema
AdventureWorks Database