Oracle9i, Release 1 (9.0.1), provides many features that support the needs of data warehousing and business intelligence. These features are typically useful for other activities such as Online Transaction Processing (OLTP). Therefore, most features described in this manual are presented in general terms, rather than emphasizing their data warehousing use.
These are some of the Oracle features that are designed to support data warehousing and business intelligence:
Parallelism in queries, data loading, indexing, and other data manipulation
Cost-based query optimization for efficient data access
Indexing techniques specifically tailored to data warehousing needs
Advanced SQL join algorithms
Data partitioning to simplify management and enhance performance
Analytic functions for high performance queries and simpler programming