Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Star Transformation - 10g
Does anyone have an example script that creates sample fact/dimension tables and the appropriate fk relationships, bitmap indexes, etc to get a star transformation join to work in Oracle 10g?
Environment: Oracle 10.2.0.3.0 on Solaris 10.
We've been trying to get it working, but the optimizer doesn't pick this join method. An example would be great if anyone has it.
Thanks,
Abdul
![]() |
![]() |