 Data Warehousing - Best Practices
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. | | | Highlighted Tips/Articles |  | 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. | | |
| Links | | Learn More: Training, Library, Discussion Forum - Oracle Database, Data Warehouse Insider Blog, Optimizer Blog, Data Mining Blog | | Related Technologies: Oracle BI Home, Oracle Exadata Storage Technology, Oracle Retail Data Model, Oracle Communications Data Model, Data Integration , Oracle OLAP, Oracle Data Mining, Oracle Statistical Functions, Oracle Information Lifecycle Management | | 
BIWA - the Oracle BI, Data Warehousing and Analytics SIG. Join Today! | | | |
Database
Printer View