Bitmap join indexes
Sales
Customer
SELECT SUM(SALES.DOLLAR_AMOUNT
FROM Sales, Customer
WHERE Sales.cust_id = Customer.cust_id
AND CUSTOMER.STATE = California;