Northwind Database (Document! X Sample)
AdventureWorks Database / Sales Schema / Sales.SalesTaxRate Table / AK_SalesTaxRate_StateProvinceID_TaxType Index
In This Topic
    AK_SalesTaxRate_StateProvinceID_TaxType Index
    In This Topic
    Description
    Unique nonclustered 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
     StateProvinceIDState, province, or country/region the sales tax applies to.Ascending
     TaxType1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.Ascending
    Index Statistics
    Average key length9.00
    Density0.80
    Rows in the Table29
    Rows Sampled29
    Distribution Steps22
    UpdatedOct 27 2017 2:33PM
    See Also

    Related Objects

    Sales.SalesTaxRate Table
    Sales Schema
    AdventureWorks Database

     

     

    © 2018 All Rights Reserved.

    Send comments on this topic.