Unique nonclustered index.
File Group | PRIMARY |
Space Used | 16.00 KB |
Fill Factor | 0 |
Do not Recompute Statistics | |
Full Text Key | |
Clustered Index | |
Primary Key Index | |
Unique Index | |
Pad Index |
Column | Description | Sort Order | |
---|---|---|---|
StateProvinceID | State, province, or country/region the sales tax applies to. | Ascending | |
TaxType | 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions. | Ascending |
Average key length | 9.00 |
Density | 0.80 |
Rows in the Table | 29 |
Rows Sampled | 29 |
Distribution Steps | 22 |
Updated | Oct 27 2017 2:33PM |
Sales.SalesTaxRate Table
Sales Schema
AdventureWorks Database