Index: IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode Index: IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode| Property | Value |
|---|---|
| Name | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode |
| ID | 3 |
| Index Type | NONCLUSTERED |
| Unique |
|
| Filegroup Name | PRIMARY |
| Ignore Duplicate Key |
|
| Primary Key |
|
| Unique Constraint |
|
| Fill Factor | 0 |
| Padded |
|
| Disabled |
|
| Hypothetical |
|
| Allow Row Locks |
|
| Allow Page Locks |
|
| Has Filter |
|
| Filter Definition |
| Name | Value |
|---|---|
| MS_Description | Nonclustered index. |
| Column Name | Datatype | Descending Key | Included Column | Key Ordinal | Partition Ordinal |
|---|---|---|---|---|---|
| AddressLine1 | nvarchar |
|
|
1 | Not a partitioning column |
| AddressLine2 | nvarchar |
|
|
2 | Not a partitioning column |
| City | nvarchar |
|
|
3 | Not a partitioning column |
| StateProvinceID | int |
|
|
4 | Not a partitioning column |
| PostalCode | nvarchar |
|
|
5 | Not a partitioning column |