Oracle Data Warehouse Tuning for 10g

459

Index

defined, 132

with dimension objects, 132–36

manual, 134

query rewrite, 133, 325

Join materialized views, 94–97

benefits, 94

dropping/recreating, 111

query rewrite with, 128

See also

Materialized views

Joins, 179–84, 324

aggregations and, 97

anti, 180

creating, 179–81

cross, 180

efficient, 179

fast refresh requirements, 97

hash, 181–82

inefficient, 180

intersections, 179

nested loop, 181

outer, 180, 279

partition-wise, 155–57

queries, pre-creating, 96–97

query rewrite on, 110

range, 179

self, 179

sort merge, 182–83

tuning, 179, 183–84

KISS rule, 163

Lag and lead, 251, 255

LAG function, 275, 276

LAST function, 274

LEAD function, 275, 276

LIKE pattern matching, 173

Linear regressions, 252

List partitioning

CREATE TABLE syntax, 146–47

defined, 140

query rewrite and, 330–31

uses, 141

See also

Partitioning

Load filters, 377

Local indexes, 141

Logical extraction, 355

Logical operators, 175

Low cardinality, 40

Matching

entire query strings, 321–23

pieces of queries, 324–30

Materialized view logs, 83

altering, 90, 91

creating, 88–90

dropping, 90–91, 110

entries, 88–89

purging, 108

requirement, 88

Materialized views, 8, 79–112

access, 81

in aggregation precalculation, 80

aggregations/filtering, 91–94

altering, 90, 91

analyzing, 102–9

benefits, 80–81

CUBE clause and, 235, 236

defined, 41, 79

dropping, 90–91

existing, registering, 87

explaining, 105–6

faster, 109–12

fast refresh, 83

formats, 91

GROUP BY clause extensions and, 235–

42

importance to data warehouses, 386

join, 94–97

in LRU list, 88