Hi,

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.

Thanks in anticipation,
Srikanth