Your bitmap join index experience
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 4 Jan 2009 12:19:58 -0800 (PST)
I'd like to ask about your experience with bitmap join indexes.
There has been a lot of discussion about not using bitmap indexes in OLTP
environments. However I'm wondering if anyone has seen anything different with
respect to bitmap join indexes. Do you still see the same performance impacts
with bitmap join indexes in OLTP systems or do they tend to do better because
of the nature of the join columns (Often PK's that are much slower with respect
to changes than other columns).
Any feedback or experience you would like to share?
RF
Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
Other related posts:
