Sep 092013
 
create bitmap index can_be_constructed
on     the_join_of_tables (
  eliminating_a_table
)
from   the_join_of_tables, 
       you_frequently_do
where  your_need_for_speed = insatiable;

A rarely used feature in my experience, bitmap join indexes can work well 
to eliminate joins from dimensions to fact tables in data warehouses, 
provided you don't need to update both tables in the join at the same time!

For a more detailed discussion, you can see aritles from Richard Niemiec here and here. For a quick script of the above, keep reading.
Continue reading »