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 - 15:49:54 CDT
