Northwind Database (Document! X Sample)
AdventureWorks Database / Person Schema / Person.BusinessEntityAddress Table / IX_BusinessEntityAddress_AddressID Index
In This Topic
    IX_BusinessEntityAddress_AddressID Index
    In This Topic
    Description
    Nonclustered index.
    Properties
    File GroupPRIMARY
    Space Used368.00 KB
    Fill Factor0
    Do not Recompute Statistics
    Full Text Key
    Clustered Index
    Primary Key Index
    Unique Index
    Pad Index
    Columns
     ColumnDescriptionSort Order
    Primary KeyPrimary key. Foreign key to Address.AddressID.Ascending
    Index Statistics
    Average key length12.00
    Density1.00
    Rows in the Table19614
    Rows Sampled19614
    Distribution Steps5
    UpdatedOct 27 2017 2:33PM
    See Also