Answers

Question and Answer:

  Home  BO Designer

⟩ What is is the Guidelines to Build Universe with Better Performance? R Performance tuning Issues of Universes?

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

 150 views

More Questions for you: