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

Thanks

Ravi

adding to the answer is

1. see that ur desgin schema is not having any loops cartesain products fan traps chasm traps etc that will give u the wrong data and the performance might be a problem is those cases.