This book will show you how to:
- Use Oracle8 table and index partitioning to enhance your warehouse
- Effectively use bitmapped indexes to speed data warehouse queries
- Easily implement STAR query joins to maximize performance
- Provide multidimensional data access without buying expensive software
- Cache small, frequently referenced tables in the Oracle buffer
- Determine when indexes require rebuilding and cluster the index with the table
- Use the Oracle utilities to populate and maintain your Oracle warehouse
- Use Oracle8 table and index partitioning to enhance your warehouse
- Effectively use bitmapped indexes to speed data warehouse queries
- Easily implement STAR query joins to maximize performance
- Provide multidimensional data access without buying expensive software
- Cache small, frequently referenced tables in the Oracle buffer
- Determine when indexes require rebuilding and cluster the index with the table
- Use the Oracle utilities to populate and maintain your Oracle warehouse