Oracle data warehousing best practices ensure that your Oracle system will leverage the full capabilities of Oracle Database 11 g. Read on to learn more about what features you should be taking advantage of to achieve extreme performance on your data warehouse.
Managing Optimizer statistics in a Data Warehouse on Oracle Database 11 g Knowing when and how to gather optimizer statistics has become somewhat of a dark art especially in a data warehouse environment where statistics maintenance can be hindered by the fact that the length of time it takes to gather statistics will grow proportionally with your data set. By default the DBMS_STATS packages will gather global (table level), partition level, and sub-partition statistics for each of the tables in the database. You may wonder if the optimizer truly need statistics at every level for a partitioned table or if time could be saved by skipping one or more levels? The answer to this question and many more can be found here.