Northwind Database (Document! X Sample)
AdventureWorks Database / Production Schema / Production.BillOfMaterials Table / AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate Index
In This Topic
    AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate Index
    In This Topic
    Description
    Clustered index.
    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
     ProductAssemblyIDParent product identification number. Foreign key to Product.ProductID.Ascending
     ComponentIDComponent identification number. Foreign key to Product.ProductID.Ascending
     StartDateDate the component started being used in the assembly item.Ascending
    Index Statistics
    Average key length15.85
    Density0.12
    Rows in the Table2679
    Rows Sampled2679
    Distribution Steps161
    UpdatedOct 27 2017 2:33PM
    See Also

    Related Objects

    Production.BillOfMaterials Table
    Production Schema
    AdventureWorks Database

     

     

    © 2018 All Rights Reserved.

    Send comments on this topic.