- Inputs to Query -

 Table 'Customers'
    Using index 'PrimaryKey'
    Having Indexes:
   PrimaryKey 91 entries, 1 page, 91 values
      which has 1 column, fixed, unique, primary-key, no-nulls
   PostalCode 91 entries, 1 page, 87 values
      which has 1 column, fixed
   CompanyName 91 entries, 1 page, 91 values
      which has 1 column, fixed
    City 91 entries, 1 page, 69 values
      which has 1 column, fixed

 Table 'Order Details'
    Using index 'OrdersOrder Details'
    Having Indexes:
   OrdersOrder Details 2155 entries, 5 pages, 830 values
      which has 1 column, fixed
   OrderID 2155 entries, 5 pages, 830 values
      which has 1 column, fixed

 Table 'Orders'

 Table 'Products'
    Using index 'PrimaryKey'
    Having Indexes:
   PrimaryKey 77 entries, 1 page, 77 values
      which has 1 column, fixed, unique, clustered and/or counter, primary-key, no-nulls
   CategoryID 77 entries, 1 page, 8 values
      which has 1 column, fixed
   CategoriesProducts 77 entries, 1 page, 8 values
      which has 1 column, fixed

 - End inputs to Query -


 01) Restrict rows of table Orders
      by scanning
      testing expression "Orders.ShipCity="Madrid""

 02) Inner Join result of '01)' to table 'Order Details'
      using index 'Order Details!OrdersOrder Details'
      join expression "Orders.OrderID=[Order Details].OrderID"

 03) Inner Join result of '02)' to table 'Products'
      using index 'Products!PrimaryKey'
      join expression "[Order Details].ProductID=Products.ProductID"

 04) Inner Join result of '03)' to table 'Customers'
      using index 'Customers!PrimaryKey'
      join expression "Orders.CustomerID=Customers.CustomerID"