If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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

Originally posted by Nugpot Thanks for the reply Tamilselvan,
There are no Bitmap indexes in the database right now(all the indexes are B*tree). Do we need to have bitmap indexes for the star transformation to work?
Thanks
Vj

... and when/if you make those bitmap indexes collect histograms for the bitmap-indexed columns.