Non clustered SQL 2005 Adventure Works OLTP

SQL 2005 Adventure Works OLTP

The indicies listed are not clustered.



AK_Address_rowguid on Person.Address
AK_AddressType_Name on Person.AddressType
AK_AddressType_rowguid on Person.AddressType
AK_Contact_rowguid on Person.Contact
AK_ContactType_Name on Person.ContactType
AK_CountryRegion_Name on Person.CountryRegion
AK_CreditCard_CardNumber on Sales.CreditCard
AK_Culture_Name on Production.Culture
AK_Currency_Name on Sales.Currency
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode on Sales.CurrencyRate
AK_Customer_AccountNumber on Sales.Customer
AK_Customer_rowguid on Sales.Customer
AK_CustomerAddress_rowguid on Sales.CustomerAddress
AK_Department_Name on HumanResources.Department
AK_Document_FileName_Revision on Production.Document
AK_Employee_LoginID on HumanResources.Employee
AK_Employee_NationalIDNumber on HumanResources.Employee
AK_Employee_rowguid on HumanResources.Employee
AK_EmployeeAddress_rowguid on HumanResources.EmployeeAddress
AK_Location_Name on Production.Location
AK_Product_Name on Production.Product
AK_Product_ProductNumber on Production.Product
AK_Product_rowguid on Production.Product
AK_ProductCategory_Name on Production.ProductCategory
AK_ProductCategory_rowguid on Production.ProductCategory
AK_ProductDescription_rowguid on Production.ProductDescription
AK_ProductInventory_rowguid on Production.ProductInventory
AK_ProductModel_Name on Production.ProductModel
AK_ProductModel_rowguid on Production.ProductModel
AK_ProductProductPhoto_ProductID_ProductPhotoID on Production.ProductProductPhoto
AK_ProductSubcategory_Name on Production.ProductSubcategory
AK_ProductSubcategory_rowguid on Production.ProductSubcategory
AK_SalesOrderDetail_rowguid on Sales.SalesOrderDetail
AK_SalesOrderHeader_rowguid on Sales.SalesOrderHeader
AK_SalesOrderHeader_SalesOrderNumber on Sales.SalesOrderHeader
AK_SalesPerson_rowguid on Sales.SalesPerson
AK_SalesPersonQuotaHistory_rowguid on Sales.SalesPersonQuotaHistory
AK_SalesTaxRate_rowguid on Sales.SalesTaxRate
AK_SalesTaxRate_StateProvinceID_TaxType on Sales.SalesTaxRate
AK_SalesTerritory_Name on Sales.SalesTerritory
AK_SalesTerritory_rowguid on Sales.SalesTerritory
AK_SalesTerritoryHistory_rowguid on Sales.SalesTerritoryHistory
AK_ScrapReason_Name on Production.ScrapReason
AK_Shift_Name on HumanResources.Shift
AK_Shift_StartTime_EndTime on HumanResources.Shift
AK_ShipMethod_Name on Purchasing.ShipMethod
AK_ShipMethod_rowguid on Purchasing.ShipMethod
AK_SpecialOffer_rowguid on Sales.SpecialOffer
AK_SpecialOfferProduct_rowguid on Sales.SpecialOfferProduct
AK_StateProvince_Name on Person.StateProvince
AK_StateProvince_rowguid on Person.StateProvince
AK_StateProvince_StateProvinceCode_CountryRegionCode on Person.StateProvince
AK_Store_rowguid on Sales.Store
AK_StoreContact_rowguid on Sales.StoreContact
AK_UnitMeasure_Name on Production.UnitMeasure
AK_Vendor_AccountNumber on Purchasing.Vendor
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode on Person.Address
IX_Address_StateProvinceID on Person.Address
IX_BillOfMaterials_UnitMeasureCode on Production.BillOfMaterials
IX_Contact_EmailAddress on Person.Contact
IX_CountryRegionCurrency_CurrencyCode on Sales.CountryRegionCurrency
IX_Customer_TerritoryID on Sales.Customer
IX_Employee_ManagerID on HumanResources.Employee
IX_EmployeeDepartmentHistory_DepartmentID on HumanResources.EmployeeDepartmentHistory
IX_EmployeeDepartmentHistory_ShiftID on HumanResources.EmployeeDepartmentHistory
IX_JobCandidate_EmployeeID on HumanResources.JobCandidate
IX_ProductInventory_ProductID on Production.ProductInventory
IX_ProductReview_ProductID_Name on Production.ProductReview
IX_ProductVendor_UnitMeasureCode on Purchasing.ProductVendor
IX_ProductVendor_VendorID on Purchasing.ProductVendor
IX_PurchaseOrderDetail_ProductID on Purchasing.PurchaseOrderDetail
IX_PurchaseOrderHeader_EmployeeID on Purchasing.PurchaseOrderHeader
IX_PurchaseOrderHeader_VendorID on Purchasing.PurchaseOrderHeader
IX_SalesOrderDetail_ProductID on Sales.SalesOrderDetail
IX_SalesOrderHeader_CustomerID on Sales.SalesOrderHeader
IX_SalesOrderHeader_SalesPersonID on Sales.SalesOrderHeader
IX_ShoppingCartItem_ShoppingCartID_ProductID on Sales.ShoppingCartItem
IX_SpecialOfferProduct_ProductID on Sales.SpecialOfferProduct
IX_Store_SalesPersonID on Sales.Store
IX_StoreContact_ContactID on Sales.StoreContact
IX_StoreContact_ContactTypeID on Sales.StoreContact
IX_TransactionHistory_ProductID on Production.TransactionHistory
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID on Production.TransactionHistory
IX_TransactionHistoryArchive_ProductID on Production.TransactionHistoryArchive
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID on Production.TransactionHistoryArchive
IX_VendorAddress_AddressID on Purchasing.VendorAddress
IX_VendorContact_ContactID on Purchasing.VendorContact
IX_VendorContact_ContactTypeID on Purchasing.VendorContact
IX_WorkOrder_ProductID on Production.WorkOrder
IX_WorkOrder_ScrapReasonID on Production.WorkOrder
IX_WorkOrderRouting_ProductID on Production.WorkOrderRouting
PXML_Contact_AddContact on Person.Contact
PXML_Individual_Demographics on Sales.Individual
PXML_ProductModel_CatalogDescription on Production.ProductModel
PXML_ProductModel_Instructions on Production.ProductModel
PXML_Store_Demographics on Sales.Store
XMLPATH_Individual_Demographics on Sales.Individual
XMLPROPERTY_Individual_Demographics on Sales.Individual
XMLVALUE_Individual_Demographics on Sales.Individual

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.