Front cover; copyright; table of contents; Contents at a Glance; Contents; front matter; Preface; Introduction to Data Warehouse Tuning; The Origin and History of Data Warehouses; Separation of OLTP and Data Warehouse Databases; Tuning a Data Warehouse; What Is in this Book?; Sample Databases in This Book; body; 1 The Basics of Data Warehouse Data Modeling; 2 Introducing Data Warehouse Tuning; 3 Effective Data Warehouse Indexing; 4 Materialized Views and Query Rewrite; 5 Oracle Dimension Objects; 6 Partitioning and Basic Parallel Processing; 7 The Basics of SQL Query Code Tuning.