I am trying to tune an Oracle data warehouse query, which is developed on a star schema. I am trying to implement star transformation (9i new future). I have set a STAR_TRANSFORMATION_ENABLED = TRUE for my database.
My fact table has bitmap indexes and my dimension tables are with normal (B-Tree) index.
My question is how I can confirm that my Star transformation is working. My report is now running in a one minute but my manager asking me to run it for one second.
Can any one help??
My fact table has bitmap indexes and my dimension tables are with normal (B-Tree) index.
My question is how I can confirm that my Star transformation is working. My report is now running in a one minute but my manager asking me to run it for one second.
Can any one help??