Forum OpenACS Development: Response to Oracle SE vs. EE

Posted by Don Baccus on
OK, I've removed the bitmap indexes and replaced them with default
b-tree indexes.  I've left the bitmap indexes in as comments.

While bitmap indexes perhaps make sense for objects and their
friends, I certainly don't see why they're needed for apm packages!

How many packages are there in a full installation?  A few dozen?
The APM spends all if its time parsing .info files with a Tcl
parser, not extracting rows from the package, package version, and
package files tables!  A b-tree index is certainly sufficient, and I
bet that for some of the queries Oracle selects a sequential scan
anyway (indexed scans can actually be slower on small tables than a
sequential scan).