| |
| |
| Preface | |
| |
| |
| Introduction to Data Warehouse Tuning | |
| |
| |
| |
| Data Warehouse Data Modeling | |
| |
| |
| |
| The Basics of Data Warehouse Data Modeling | |
| |
| |
| |
| The Relational and Object Data Models | |
| |
| |
| |
| Data Modeling for Data Warehouses | |
| |
| |
| |
| Introducing Data Warehouse Tuning | |
| |
| |
| |
| Let's Build a Data Warehouse | |
| |
| |
| |
| Methods for Tuning a Data Warehouse | |
| |
| |
| |
| Effective Data Warehouse Indexing | |
| |
| |
| |
| The Basics of Indexing | |
| |
| |
| |
| Star Queries and Star Query Transformations | |
| |
| |
| |
| Index Organized Tables and Clusters | |
| |
| |
| |
| Materialized Views and Query Rewrite | |
| |
| |
| |
| What Is a Materialized View? | |
| |
| |
| |
| Materialized View Syntax | |
| |
| |
| |
| Types of Materialized Views | |
| |
| |
| |
| Analyzing and Managing Materialized Views | |
| |
| |
| |
| Making Materialized Views Faster | |
| |
| |
| |
| Oracle Dimension Objects | |
| |
| |
| |
| What Is a Dimension Object? | |
| |
| |
| |
| Dimension Object Syntax | |
| |
| |
| |
| Dimension Object Metadata | |
| |
| |
| |
| Dimension Objects and Performance | |
| |
| |
| |
| Partitioning and Basic Parallel Processing | |
| |
| |
| |
| What Are Partitioning and Parallel Processing? | |
| |
| |
| |
| Partitioned Table Syntax | |
| |
| |
| |
| Tuning Queries with Partitioning | |
| |
| |
| |
| Other Partitioning Tricks | |
| |
| |
| |
| Partitioning Metadata | |
| |
| |
| |
| Tuning SQL Code in a Data Warehouse | |
| |
| |
| |
| The Basics of SQL Query Code Tuning | |
| |
| |
| |
| Basic Query Tuning | |
| |
| |
| |
| How Oracle SQL Is Executed | |
| |
| |
| |
| Tools for Tuning Queries | |
| |
| |
| |
| Aggregation Using Group By Clause Extensions | |
| |
| |
| |
| What Are Group By Clause Extensions? | |
| |
| |
| |
| Group By Clause Extensions | |
| |
| |
| |
| Group By Clause Extensions and Materialized Views | |
| |
| |
| |
| Combining Groupings Together | |
| |
| |
| |
| Analysis Reporting | |
| |
| |
| |
| What Is Analysis Reporting? | |
| |
| |
| |
| Types of Analysis Reporting | |
| |
| |
| |
| Introducing Analytical Functions | |
| |
| |
| |
| Specialized Analytical Syntax | |
| |
| |
| |
| Analysis in Practice | |
| |
| |
| |
| Modeling with the MODEL Clause | |
| |
| |
| |
| What Is the MODEL Clause? | |
| |
| |
| |
| MODEL Clause Syntax | |
| |
| |
| |
| What Can the MODEL Clause Do? | |
| |
| |
| |
| Performance and the MODEL Clause | |
| |
| |
| |
| Advanced Topics | |
| |
| |
| |
| Query Rewrite | |
| |
| |
| |
| What Is Query Rewrite? | |
| |
| |
| |
| How the Optimizer Rewrites Queries | |
| |
| |
| |
| Affecting Query Rewrite Performance | |
| |
| |
| |
| Parallel Processing | |
| |
| |
| |
| What Is Parallel Processing? | |
| |
| |
| |
| Degree of Parallelism (Syntax) | |
| |
| |
| |
| Configuration Parameters | |
| |
| |
| |
| Demonstrating Parallel Execution | |
| |
| |
| |
| Performance Views | |
| |
| |
| |
| Parallel Execution Hints | |
| |
| |
| |
| Parallel Execution Query Plans | |
| |
| |
| |
| Data Loading | |
| |
| |
| |
| What Is Data Loading? | |
| |
| |
| |
| Extraction | |
| |
| |
| |
| Transportation Methods | |
| |
| |
| |
| Loading and Transformation | |
| |
| |
| |
| Data Warehouse Architecture | |
| |
| |
| |
| What Is a Data Warehouse? | |
| |
| |
| |
| Tuning Hardware Resources for Data Warehousing | |
| |
| |
| |
| Capacity Planning | |
| |
| |
| |
| OLAP and Data Mining | |
| |
| |
| |
| New Data Warehouse Features in Oracle Database 10g | |
| |
| |
| |
| Sample Schemas | |
| |
| |
| |
| Sample Scripting | |
| |
| |
| |
| Syntax Conventions | |
| |
| |
| |
| Sources of Information | |
| |
| |
| Index | |