I was thinking on turning the STAR_TRANSFORMATION_ENABLED parameter to true in our new data warehouse to help us in any performance gains. I was wondering if we need Bitmap indexes to be created on our tables for the star_transformation to work. Please advice
Db - 8.1.7
server- unix
Thanks
Vj