Index

A B C D E F G H I M N O P Q R S T U V W

A

adding

mapping operators, 5.4

analytic capabilities, 7.1

analytic SQL, 7.1

ARCHIVELOG mode

as a best practice, 11.2.1

attribute properties, setting, 5.8

attributes

connecting, 5.6.1

level attributes, 4.4.1.2

setting properties, 5.8

auto binding rules, 4.4.2.2

B

backup, 11.1

backup and recovery, 11.1

best practices, 11.2

best practices

ARCHIVELOG mode, 11.2.1

backup and recovery, 11.2

NOLOGGING, 11.2.4

read-only tablespaces, 11.2.3

RMAN, 11.2.2

tablespace differences, 11.2.5

binding

auto binding, rules, 4.4.2.2

B-tree index, 10.2.3

C

calculating moving averages, 7.1.8

calculating relative contributions, 7.1.6

column statistics, 10.1.1

common tasks

in data warehouses, 1.2.2

COMPATIBLE, 2.3.3

COMPRESS clause, 10.2.4.2

compression, 10.2.4

compression advisor interface, 10.2.4.1

connecting

attributes, 5.6.1

groups, 5.6.2

operators, 5.6

CPUs, 2.2.1.1

Create External Table Wizard, 4.3.1

creating

mappings, 5

CUBE function, 7.1.2

cubes, 4.5

dimensionality, 4.5.1.2

example, 4.5.1.3

measures, 4.5.1.1

relational implementation, 4.5.2.1

D

data compression, 9.3.1

data warehouses

common tasks, 1.2.2

key characteristics of, 1.2.1

setting up, 2.2, 2.3

tools, 1.4

data warehousing security, 12

DB_BLOCK_SIZE, 2.3.3

DB_FILE_MULTIBLOCK_READ_COUNT, 2.3.3

DBMS_COMPRESSION package, 10.2.4.1

DBMS_STATS package, 10.1.1

dd utility, 2.2.2.1

defining

mappings, 5

degree of parallelism (DOP), 10.3.1.2

densification, 7.2

dimensions

dimension roles, 4.4.1.4

example, 4.4.1.6

hierarchies, 4.4.1.3

implementing, 4.4.2

level attributes, 4.4.1.2

level relationships, 4.4.1.5

star schema implementation, 4.4.2.1

disks

needed, 2.2.1.3

E

explain plan

analyzing, 10.1.2

EXPLAIN PLAN statement, 10.1.2

explain plans, 10.1.2

external tables

creating a new definition, 4.3.1

defined, 4.3

wizard for creating, 4.3.1

F

fine-grained auditing

in data warehouses, 12.5

flat files

G

group properties, 5.8

GROUPING function, 7.1.3

GROUPING SETS function, 7.1.4

groups

connecting, 5.6.2

setting properties, 5.8

H

hardware configuration, 2.2.1

verifying, 2.2.2

hierarchies

about, 4.4.1.3

hints, 10.1.3

I

implementing

relational cubes, 4.5.2.1

star schema, 4.4.2.1

index statistics, 10.1.1

indexes

bitmap, 10.2.3

optimizing, 9.2

optimizing with SQL Access Advisor, 9.2

initialization parameters

setting, 2.3.3

interrow calcuations

performing, 7.1.7

I/O, 2.2.1.4, 9.1.1.2

monitoring, 9.1.1.2

M

mapping operators

about, 5.1

adding, 5.4

connecting, 5.6

editing, 5.5

synchronizing with Repository objects, 5.9

types of, 5.3.1

mapping operators, setting, 5.8

mappings

about, 5.1

creating, 5

defining, 5

setting properties, 5.7

materialized views, 10.2.2

memory, 2.2.1.2

memory management

parameters, 2.3.1

memory needed, 2.2.1.2

MERGE PARTITION, 9.3.1

MOVE PARTITION, 9.3.1

N

NOLOGGING

as a best practice, 11.2.4

O

offloading data

with rolling windows, 8.2

operator attributes, 5.6.1

operator properties

setting, 5.8

operators

connecting, 5.6

editing, 5.5

synchronizing with Repository objects, 5.9

operators, mapping, 5.1

adding, 5.4

connecting, 5.6

editing, 5.5

types of, 5.3.1

optimizer statistics, 10.1.1

OPTIMIZER_FEATURES_ENABLE, 2.3.3

Oracle Label Security, 12.4

in data warehouses, 12.3

Orion utility, 2.2.2.3

P

parallel execution, 10.3.1

how it works, 10.3.1.1

parallel query, 9.1.1.1, 10.3.1

monitoring, 9.1.1.1

PARALLEL_ADAPTIVE_MULTI_USER, 2.3.3

PARALLEL_MAX_SERVERS, 2.3.3

parameters

initialization, 2.3.3

memory management, 2.3.1

partition outer join, 7.2

partition pruning, 10.2.1.1

partitioning, 10.2.1

partitionwise joins, 10.2.1.2

performance

improving with compression, 10.2.4

using hints, 10.1.3

using query rewrite, 10.2.2

using SQL Access Advisor, 10.1.4

using SQL Tuning Advisor, 10.1.4

privileges

in data warehouse security, 12.2

properties

mapping, 5.7

setting, 5.8

Q

query rewrite, 2.3.3, 2.3.3, 4.4, 8.1.1, 10.2.2

QUERY_REWRITE_ENABLED, 2.3.3

QUERY_REWRITE_INTEGRITY, 2.3.3

R

range-partitioned table, 9.3.1

RANK function, 7.1.5

read-only tablespaces

as a best practice, 11.2.3

refresh, 8.1

refreshing

data warehouse, 8.1

resource consumption, 10.2

minimizing, 10.2

Resource Manager, 9.1.2

rewrite

query, 2.3.3, 2.3.3

RMAN

as a best practice, 11.2.2

roles

dimension roles, 4.4.1.4

in data warehouse security, 12.2

rolling windows, 8.2

ROLLUP function, 7.1.1

S

security

data warehouse, 12

setting

mapping properties, 5.7

sparsity, 7.2

SPLIT PARTITION, 9.3.1

SQL Access Advisor, 10.1.4

evaluating partitioning, 10.2.1.3

optimizing indexes, 9.2

SQL Tuning Advisor, 10.1.4

STAR_TRANSFORMATION_ENABLED, 2.3.3

statistics

optimizer, 10.1.1

storage

optimizing, 9.3

synchronizing

operators and Repository objects, 5.9

system statistics, 10.1.1

T

table statistics, 10.1.1

table_compress clause, 10.2.4.2

tables

U

UTLXPLAN.SQL script, 10.1.2

V

virtual private database

in data warehouses, 12.3

VPD

how it works, 12.3.1

W

wait events, 10.3.2

WITH clause, 7.3

wizards

Create External Table Wizard, 4.3.1