Northwind Database (Document! X Sample)
AdventureWorks Database / Sales Schema / Sales.SalesPersonQuotaHistory Table / PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate Index
In This Topic
    PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate Index
    In This Topic
    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