Hello,
Are the risks of creating bitmap join indexes on several
tables (2 or 3) that undergo many transactions the same as
creating a classical bitmap index (à la 8i) ? Will we be
likely to see many deadlocks arising in our alert.log and
trc files ? I.e. is J. Lewis' warning (p. 97 of Practical
Oracle8i) "bitmap indexes and OLTP systems do *not* mix"
still valid ? Or maybe at Oracle they managed to deal with
such indexes even in strongly DMLed tables in order to avoid
ORA-00060 messages ? It would be nice actually.
Thanks a lot.
Sp
Received on Thu Apr 14 2005 - 06:57:38 CDT
