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
)
