Does anyone know how we should set the parameters in SPRO for maximum performance? NOTE: We are running on Oracle 10g.
According to note 938040, these parameters should replace the DB_STATISTICS entry we used to have in RSADMIN. Is this true?
There are actually 2 sections in SPRO:
1. A global section in SPRO/SAP NetWeaver/Business Intelligence/Performance settings/Settings for Database Interfaces.
The way I understand this section is that if your DBMS is able to handle histograms, you don't have to tick the check box. Assuming we run the stats in Oracle on a daily basis, is it okay to leave the checkbox unchecked?
2. In the Oracle specific section in SPRO/SAP NetWeaver/Business Intelligence/Performance settings/Settings for Database Interfaces (Oracle).
From what I read through the help, we can speed up the index rebuild by unchecking the "Logging while index" check box. We've done some testing in C&B and so far so good for this one (we are about to test it in PROD). However, with the "Degree" field, wether we put 0 or 8 in it and we launch a massive aggregate, we haven't seen any difference. Does anyone has any experience with that field?
Thanks in advance,