Re: Star Join & Bitmapped Indexes on Oracle 7.3.4

Technically 7.3.4 does not support the bitmapped approach to star joins (hinted with STAR_TRANSFORMATION in Oracle 8), only the cartesian product of dimensions and concatenated index approach (hinted with STAR).

In fact _star_transformation_enabled is one of the hidden parameters, and the STAR_TRANSFORMATION hint exists in 7.3.4 - I've not made it work yet, and I feel it would be unsupported if it did.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Tim McCoy wrote in message ...
>Im trying to research a problem. I have an Oracle book that says that you
>must use a composite index (on the fact table) - not bitmapped indexes -
>when attempting to get an Oracle 7.3 database to choose the star join
>algorithm (also must set optimizer to choose and have analyzed the tables).
>It says that in Oracle 8, the star join CAN use bitmapped indexes but not
in
>7.3. Does anyone know if in Oracle 7.3.4 the star join DOES use the
>bitmapped indexes if they are available? I work on a system that has the
DBA
>function outsourced and the dba's there tell me that 7.3.4 star joins can
>use bitmapped indexes. Any takers on this one? Thanks in advance
>
>
Received on Tue Aug 03 1999 - 16:39:32 CDT