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
|