-
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
-
Does the application design state it uses star schema?
-
Yes, the design states that it will use the star schema.
-
In init.ore file, Set the following parameters:
Bitmap_Merge_Area_Size = 8388608
Create_Bitmap_Area_Size = 8388608
Star_Transformation_enabled = true
Query_Rewrite_enabled = true
Query_Rewrite_integrity = enforced or trusted
-
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
-
Even bitmap index is not available, STAR transformation will work with normal B-Tree indexes..
-
-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|