Indexes in Database AdventureWorks
PK_AWBuildVersion_SystemInformationID
PK_DatabaseLog_DatabaseLogID
PK_ErrorLog_ErrorLogID
AK_Department_Name
PK_Department_DepartmentID
AK_Employee_LoginID
AK_Employee_NationalIDNumber
AK_Employee_rowguid
IX_Employee_ManagerID
PK_Employee_EmployeeID
AK_EmployeeAddress_rowguid
PK_EmployeeAddress_EmployeeID_AddressID
IX_EmployeeDepartmentHistory_DepartmentID
IX_EmployeeDepartmentHistory_ShiftID
PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
PK_EmployeePayHistory_EmployeeID_RateChangeDate
IX_JobCandidate_EmployeeID
PK_JobCandidate_JobCandidateID
AK_Shift_Name
AK_Shift_StartTime_EndTime
PK_Shift_ShiftID
AK_Address_rowguid
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
IX_Address_StateProvinceID
PK_Address_AddressID
AK_AddressType_Name
AK_AddressType_rowguid
PK_AddressType_AddressTypeID
AK_Contact_rowguid
IX_Contact_EmailAddress
PK_Contact_ContactID
AK_ContactType_Name
PK_ContactType_ContactTypeID
AK_CountryRegion_Name
PK_CountryRegion_CountryRegionCode
AK_StateProvince_Name
AK_StateProvince_rowguid
AK_StateProvince_StateProvinceCode_CountryRegionCode
PK_StateProvince_StateProvinceID
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
IX_BillOfMaterials_UnitMeasureCode
PK_BillOfMaterials_BillOfMaterialsID
AK_Culture_Name
PK_Culture_CultureID
AK_Document_FileName_Revision
PK_Document_DocumentID
PK_Illustration_IllustrationID
AK_Location_Name
PK_Location_LocationID
AK_Product_Name
AK_Product_ProductNumber
AK_Product_rowguid
PK_Product_ProductID
AK_ProductCategory_Name
AK_ProductCategory_rowguid
PK_ProductCategory_ProductCategoryID
PK_ProductCostHistory_ProductID_StartDate
AK_ProductDescription_rowguid
PK_ProductDescription_ProductDescriptionID
PK_ProductDocument_ProductID_DocumentID
PK_ProductInventory_ProductID_LocationID
PK_ProductListPriceHistory_ProductID_StartDate
AK_ProductModel_Name
AK_ProductModel_rowguid
PK_ProductModel_ProductModelID
PK_ProductModelIllustration_ProductModelID_IllustrationID
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
PK_ProductPhoto_ProductPhotoID
PK_ProductProductPhoto_ProductID_ProductPhotoID
IX_ProductReview_ProductID_Name
PK_ProductReview_ProductReviewID
AK_ProductSubcategory_Name
AK_ProductSubcategory_rowguid
PK_ProductSubcategory_ProductSubcategoryID
AK_ScrapReason_Name
PK_ScrapReason_ScrapReasonID
IX_TransactionHistory_ProductID
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
PK_TransactionHistory_TransactionID
IX_TransactionHistoryArchive_ProductID
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
PK_TransactionHistoryArchive_TransactionID
AK_UnitMeasure_Name
PK_UnitMeasure_UnitMeasureCode
IX_WorkOrder_ProductID
IX_WorkOrder_ScrapReasonID
PK_WorkOrder_WorkOrderID
IX_WorkOrderRouting_ProductID
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
IX_ProductVendor_UnitMeasureCode
IX_ProductVendor_VendorID
PK_ProductVendor_ProductID_VendorID
IX_PurchaseOrderDetail_ProductID
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
IX_PurchaseOrderHeader_EmployeeID
IX_PurchaseOrderHeader_VendorID
PK_PurchaseOrderHeader_PurchaseOrderID
AK_ShipMethod_Name
AK_ShipMethod_rowguid
PK_ShipMethod_ShipMethodID
AK_Vendor_AccountNumber
PK_Vendor_VendorID
IX_VendorAddress_AddressID
PK_VendorAddress_VendorID_AddressID
IX_VendorContact_ContactID
IX_VendorContact_ContactTypeID
PK_VendorContact_VendorID_ContactID
PK_ContactCreditCard_ContactID_CreditCardID
IX_CountryRegionCurrency_CurrencyCode
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
AK_CreditCard_CardNumber
PK_CreditCard_CreditCardID
AK_Currency_Name
PK_Currency_CurrencyCode
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
PK_CurrencyRate_CurrencyRateID
AK_Customer_AccountNumber
AK_Customer_rowguid
IX_Customer_TerritoryID
PK_Customer_CustomerID
AK_CustomerAddress_rowguid
PK_CustomerAddress_CustomerID_AddressID
PK_Individual_CustomerID
AK_SalesOrderDetail_rowguid
IX_SalesOrderDetail_ProductID
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
AK_SalesOrderHeader_rowguid
AK_SalesOrderHeader_SalesOrderNumber
IX_SalesOrderHeader_CustomerID
IX_SalesOrderHeader_SalesPersonID
PK_SalesOrderHeader_SalesOrderID
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
AK_SalesPerson_rowguid
PK_SalesPerson_SalesPersonID
AK_SalesPersonQuotaHistory_rowguid
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate
PK_SalesReason_SalesReasonID
AK_SalesTaxRate_rowguid
AK_SalesTaxRate_StateProvinceID_TaxType
PK_SalesTaxRate_SalesTaxRateID
AK_SalesTerritory_Name
AK_SalesTerritory_rowguid
PK_SalesTerritory_TerritoryID
AK_SalesTerritoryHistory_rowguid
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
IX_ShoppingCartItem_ShoppingCartID_ProductID
PK_ShoppingCartItem_ShoppingCartItemID
AK_SpecialOffer_rowguid
PK_SpecialOffer_SpecialOfferID
AK_SpecialOfferProduct_rowguid
IX_SpecialOfferProduct_ProductID
PK_SpecialOfferProduct_SpecialOfferID_ProductID
AK_Store_rowguid
IX_Store_SalesPersonID
PK_Store_CustomerID
AK_StoreContact_rowguid
IX_StoreContact_ContactID
IX_StoreContact_ContactTypeID
PK_StoreContact_CustomerID_ContactID