下面是官网对于位图联合索引的说明
Use the bitmap_join_index_clause to define a bitmap join index. A bitmap join index is defined on a single table. For an index key made up of dimension table columns, it stores the fact table rowids corresponding to that key. In a data warehousing environment, the table on which the index is defined is commonly referred to as afact table, and the tables with which this table is joined are commonly referred to asdimension tables. However, a star schema is not a requirement for creating a join index.
ON In the ON clause, first specify the fact table, and then inside the parentheses specify the columns of the dimension tables on which the index is defined.
FROM In the FROM clause, specify the joined tables.
WHERE In the WHERE
