Solution : https://service.sap.com/sap/support/notes/424239 (SAP Service marketplace login required)
Key words :
cost-based optimizer reason, - activates block sampling <degree> - degree, sap profile parameter stats_dbms_stats, statistic collectionthe optional, set init<sid>, 1this parameter activates, parallel query option, sap parameter stats_dbms_stats, standard sampling type, - activates row sampling
Related Notes :
1013912 | FAQ: Oracle BW performance |
892296 | Enhancements in update statistics in BRCONNECT 7.00/7.10 |
806554 | FAQ: I/O-intensive database operations |
635564 | |
588668 | FAQ: Database statistics |
525235 | |
428212 | Using BRCONNECT to update InfoCube statistics |
408532 | Using the DBMS_STATS package for collecting statistics |
403706 | Corrections in BR*Tools Version 6.10 |
403704 | BRCONNECT - Enhanced function for Oracle DBA |