Oracle9i for data warehousing

CREATE BITMAP INDEX cust_sales_bji

ON Sales(Customer.state)

FROM Sales, Customer

WHERE Sales.cust_id = Customer.cust_id;

Bitmap join indexes

Sales

Customer

Index key is Customer.State

Sales(Customer.state)

Sales(Customer.state)

Indexed table is Sales

SELECT SUM(SALES.DOLLAR_AMOUNT

FROM Sales, Customer

WHERE Sales.cust_id = Customer.cust_id

AND CUSTOMER.STATE = ‘California’;