
72 3.2 Star Queries and Star Query Transformations
CREATE BITMAP INDEX xbj_sale_2
ON sale(time.time_id)
FROM sale, time
WHERE sale.time_id = time.time_id
NOLOGGING COMPUTE STATISTICS TABLESPACE indx;
DROP INDEX xbj_sale_3;
CREATE BITMAP INDEX xbj_sale_3
ON sale(product.product_id)
FROM sale, product
WHERE sale.product_id = product.product_id
NOLOGGING COMPUTE STATISTICS TABLESPACE indx;
DROP INDEX xbj_sale_4;
CREATE BITMAP INDEX xbj_sale_4
ON sale(industry.industry_id)
FROM sale, industry
WHERE sale.industry_id = industry.industry_id
NOLOGGING COMPUTE STATISTICS TABLESPACE indx;
Using four single column bitmap indexes for the bitmap join produces
the same result ...