Neo Ethan Posted March 7, 2019 Share Posted March 7, 2019 Hello, I have a requirement to create a star view where 1 FACT is joined to 19 dimensions and brought about 80 columns . This facts and dimensions are coming from single Oracle Data-source . This view gives me data but performance is very poor even though a single column requested from this view . The view actually has a huge data size (about 50 millions rows) . On checking the execution plan I see that it create the sub query to the view and retrieves the data . My requirement here is whenever request come for an ex. 3 columns which are coming from 3 dimension only required tables(dimensions) needs to be joined rather than joining all tables and retrieve data. Please provide solution to improve the performance here . (I tried caching but refresh time is too huge and table size is too huge ) Thanks, Neo Link to comment Share on other sites More sharing options...
Gaia Paolini Posted March 7, 2019 Share Posted March 7, 2019 what product are you referring to Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now