Northwind - indexes

Index overview

name	table	description
Categories.CategoryName	Categories	unique index on Categories
Categories.PrimaryKey	Categories	primary key index on Categories
Customers.PostalCode	Customers	index on Customers
Customers.City	Customers	index on Customers
Customers.PrimaryKey	Customers	primary key index on Customers
Customers.CompanyName	Customers	index on Customers
Customers.Region	Customers	index on Customers
Employees.PostalCode	Employees	index on Employees
Employees.LastName	Employees	index on Employees
Employees.PrimaryKey	Employees	primary key index on Employees
Order Details.PrimaryKey	Order Details	primary key index on Order Details
Order Details.ProductsOrder_Details	Order Details	foreign key index on Order Details
Order Details.OrderID	Order Details	index on Order Details
Order Details.OrdersOrder_Details	Order Details	foreign key index on Order Details
Order Details.ProductID	Order Details	index on Order Details
Orders.EmployeesOrders	Orders	foreign key index on Orders
Orders.CustomersOrders	Orders	foreign key index on Orders
Orders.ShipPostalCode	Orders	index on Orders
Orders.ShippersOrders	Orders	foreign key index on Orders
Orders.EmployeeID	Orders	index on Orders
Orders.ShippedDate	Orders	index on Orders
Orders.CustomerID	Orders	index on Orders
Orders.OrderDate	Orders	index on Orders
Orders.PrimaryKey	Orders	primary key index on Orders
Products.SupplierID	Products	index on Products
Products.ProductName	Products	index on Products
Products.PrimaryKey	Products	primary key index on Products
Products.CategoryID	Products	index on Products
Products.CategoriesProducts	Products	foreign key index on Products
Products.SuppliersProducts	Products	foreign key index on Products
Shippers.PrimaryKey	Shippers	primary key index on Shippers
Suppliers.PostalCode	Suppliers	index on Suppliers
Suppliers.PrimaryKey	Suppliers	primary key index on Suppliers
Suppliers.CompanyName	Suppliers	index on Suppliers