MV and Bitmap indexes in Standard Edition
Hi DBA's
I have a enterprise edition 10.2.0.3 database which may be upgraded to 11.2.0.3 EE. It has many Materialized view with query rewrite enabled. If i downgrade to standard edition, what will be the impact? I know query rewrite is a feature of EE and not SE and SEO. There are Bitmap indexes too in the database which i guess needs to be recreated as normal b-tree indexes.
I know that bitmap is not a feautre of SE. Only one advantage i see that the updates will be faster if there is normal index as DML are slow if there is Bitmap index.
What will be the impact on the database performance if there is standard edition which does not have query rewrite and Bitmap features?
Thanks
DBA's are the heroes behind the screen whereas Developers are heroes on the screen.