Question
What is is the guidelines to build universe with better performance? r performance tuning issues of universes?
Answers
Guidelines are provided in the Universe guide:
Here is the Summary:
1) Modify the array fetch size in SBO file
2) Assign table weights and change the default order of the tables in a query by changing parameter in PRM file
3) Use shorcut joins to avoid unnecessary tables that may come in Query
4) Use aggregated tables.   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q Why are you interested in our company?
  • Q explain simple squamous epithelium
  • Q How Cloud Computing is important platform as a service?
  • Q In which year India won the ICC world cup under the captaincy of M. S. Dhoni for the second time?
  • Q How we can do different types of narrative reports in obiee?
  • Q Can you clone from multi node system to single node system and vice versa ?
  • Q Which vessels make the food material, gases, waste exchange make possible?
  • Q Sinking fund is created from?
  • Q What is meant by reconciling an account?
  • Q Mention the floral formula of Ranunculaceae ?
  • Q A average male will have 2000 what during his lifetime