1.

What Is Is The Guidelines To Build Universe With Better Performance? R Performance Tuning Issues Of Universes?

Answer»

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.

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.


Discussion

No Comment Found

Related InterviewSolutions