Jump to content
We have recently updated our Privacy Statement, available here ×

Star View

Neo Ethan

Recommended Posts


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 )



Link to comment
Share on other sites

  • Create New...