| Questionable Indexes | ||||||||
|---|---|---|---|---|---|---|---|---|
| Fact | GeneralSchema | GeneralObject | SQLServerName | table_type | index_type | GeneralColumn | SQLServerType | Question |
| 39 | HumanResources | Employee | AK_Employee_LoginID | 1 | 2 | LoginID | nvarchar(0256) | indexing key has long string |
| 39 | Person | Address | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode | 1 | 2 | AddressLine1 | nvarchar(0060) | indexing key has long string |
| 39 | Person | Address | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode | 1 | 2 | AddressLine2 | nvarchar(0060) | indexing key has long string |
| 39 | Person | Address | IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode | 1 | 2 | City | nvarchar(0030) | indexing key has long string |
| 39 | Person | EmailAddress | IX_EmailAddress_EmailAddress | 1 | 2 | EmailAddress | nvarchar(0050) | indexing key has long string |
| 39 | Production | Document | IX_Document_FileName_Revision | 1 | 2 | FileName | nvarchar(0400) | indexing key has long string |
| 39 | Production | Product | AK_Product_ProductNumber | 1 | 2 | ProductNumber | nvarchar(0025) | indexing key has long string |
| 39 | Sales | CreditCard | AK_CreditCard_CardNumber | 1 | 2 | CardNumber | nvarchar(0025) | indexing key has long string |
| 39 | Sales | SalesOrderHeader | AK_SalesOrderHeader_SalesOrderNumber | 1 | 2 | SalesOrderNumber | nvarchar(0025) | indexing key has long string |
| 39 | Sales | ShoppingCartItem | IX_ShoppingCartItem_ShoppingCartID_ProductID | 1 | 2 | ShoppingCartID | nvarchar(0050) | indexing key has long string |