We are working in a retail environment. Most of the table in our database has Company code, Region Code, Branch Code as common columns. Inorder to improve performance, we have to create table with the specified columns by having a Cluster or Index Organized Table(IOT) or Bitmap Index. Also, when we create a Cluster, we cannot create a IOT or Bitmap Index and Vice versa.
The query which I would like to ask is which among the three(Cluster,IOT,Bitmap Index) will be faster to update and query for the tables.
I suppose you're looking for real life experience, I don't have any yet and am curious as to what others think about the question, but I can point you to some docs to read in the meantime.
Check out [url]http://technet.oracle.com/doc/oracle8i_816/server.816/a76992/toc.htm[/url] , you'll need a free technet registration. Just look for the sections on Bitmap Indexes, Clusters, and IOTs, I didn't see one place comparing/contrasting the three, but you can read all the 'when to use' and 'when not to use' of the three individually.