rahulras wrote:I've (rarely) seen what appeared to be star plans without bitmap indexes but they performed poorly. My understanding agrees with yours - bitmap indexes help the process along
I am on v18.104.22.168.
My questions are
1) If I create btree index on the foreign keys in fact table ( instead of bitmap ), will the star transformation not happen?
2) I might have to create the fact table as Index Organized table (why? very long answer) I guess, start transformation will not work in that case as well. Am I correct?I am not aware of any requirement to use IOTs for star transfomations. What is the source of this idea?
3) Are there any special partitioning facilities/concepts which might be helpful in star schema/transformation ?Not that I am aware of