SAP Note 129252 - Oracle DB Statistics for BW Tables

Composant : BW ORACLE - Demand Planning

Solution : https://service.sap.com/sap/support/notes/129252 (Connexion à SAP Service Marketplace requise)

Mots Clés :
cost-based optimizer requires statistical information, 20-million-rows fact table takes, cost based optimizer choosing, cost-based optimizer works, bw query performance relies, cost-based optimizer, bw-triggered statistics runs, business information warehouse, respective bw runs, oracle database platform

Notes associées :

1013912FAQ: Oracle BW performance
797629FAQ: Oracle histograms
588668FAQ: Database statistics
555030Deactivating BW-initiated DB statistics
524341Updating the statistics for individual partitions
428212Using BRCONNECT to update InfoCube statistics
421795Report SAP_ANALYZE_ALL_INFOCUBES
403704BRCONNECT - Enhanced function for Oracle DBA
393655DP 3.0: Administer performance
370601Composite SAP note: APO 3.0 and 3.1 performance
364305ORA-1405:fetched column value is null
363092Demand Planning: Performance Mass Processing
351163Creating ORACLE DB statistics using DBMS_STATS
323090Performance problems due to degenerated indexes
314719BW2.0 ORACLE FEATURES
184905Collective note Performance BW 2.0
156319Collective note performance BW 1.2B
16083Standard jobs, reorganization jobs