index_P

P

PARALLEL clause, 58

Parallel direct path load, 241–43

defined, 241

disable constraints/triggers, 242

drop indexes, 242

illustrated, 242

inspect log, 243

load data, 242

reenable constraints/triggers, 243

See also Direct path load

Parallelism, 130–34

defined, 130

degree, setting, 132

hardware requirements, 133–34

operations benefiting from, 131

Parallel management tasks, 381–82

Parallel queries, 131

PARTITION BY clause, 111–13, 118

defined, 111

illustrated, 112

rank calculations with, 113

Partition Change Tracking (PCT), 155–57, 377

defined, 155

illustrated, 155

query rewrite and, 187–89

refresh, 155, 157

stale materialized views and, 157

support, 157

Partitioned indexes, 88–92

global, 88–89

local, 90–92

See also Indexes

Partitioning, 53–54, 76–91

benefits, 76

composite, 82–85

criteria, 54

defined, 53

hash, 79–80

illustrated, 53

list, 80–81

materialized views, 146–47

performance and, 77

process, 76–88

range, 77–79

techniques, 53

by time, 77

Partition keys

defined, 76

multicolumn, 86–88

for range partitioning, 86–87

Partitions

adding/dropping, 369–70

exchanging, 370

facilitate management, 376–77

hash, coalescing, 375

index, 372

list, 375

of local indexes, 374

maintenance, 369–77

merging, 371–73

moving, 376

range, 375

splitting, 371, 373–75

truncating, 375–76

Partition-wise join optimization, 98

PERCENTILE_CONT() function, 123–24

PERCENTILE_DISC() function, 123–24

PERCENT_RANK() function, 113, 124

Performance dependencies, 67

design for, 28–29

fast refresh, 154

partitioning and, 77

query, 382

SQL*Loader, 235–37

Performance Manager, 383

Plan stability, 384–89

defined, 384

outline creation, 384–85

outline edit, 386–89

outline use, 386

Portals

data warehouses and, 404

defined, 403

Oracle example, 404

reasons for using, 403–7

Portlets, 406

Postload operations, 273–77

database, table, partition backup, 277

dimension verification, 273

materialized views, refreshing, 274–76

optimizer statistics for materialized views, 276–77

optimizer statistics for tables, 273

publish data, 277

Preconfigured databases, 31

Predicator variance, 484

Predictive Modeling Markup Language (PMML) standard, 484

Prefixed local indexes, 90–91

PREPARE_SUBSCRIBER_VIEW procedure, 219

Presentation Wizard, 461–66

crosstab layout, 463

dimension member selection, 463

for graph creation, 468–70

illustrated, 461

measures and dimensions selection, 462

report formats, 461

Privileges

ALTER ANY MATERIALIZED VIEW, 148

CREATE MATERIALIZED VIEW, 147–48

defining, 65–66

Easy Shopping Inc., 65–66

object, 56

system, 67

Projects, 281