Northwind Database (Document! X Sample)
AdventureWorks Database / Person Schema / Person.Address Table / IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode Index
In This Topic
    IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode Index
    In This Topic
    Description
    Nonclustered index.
    Properties
    File GroupPRIMARY
    Space Used1,728.00 KB
    Fill Factor0
    Do not Recompute Statistics
    Full Text Key
    Clustered Index
    Primary Key Index
    Unique Index
    Pad Index
    Columns
     ColumnDescriptionSort Order
     AddressLine1First street address line.Ascending
     AddressLine2Second street address line.Ascending
     CityName of the city.Ascending
     StateProvinceIDUnique identification number for the state or province. Foreign key to StateProvince table.Ascending
     PostalCodePostal code for the street address.Ascending
    Index Statistics
    Average key length70.63
    Density0.70
    Rows in the Table19614
    Rows Sampled19614
    Distribution Steps192
    UpdatedOct 27 2017 2:33PM
    See Also

    Related Objects

    Person.Address Table
    Person Schema
    AdventureWorks Database

     

     

    © 2018 All Rights Reserved.

    Send comments on this topic.