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.7
attributes
connecting, 5.6.3
level attributes, 4.4.1.2
setting properties, 5.7
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 parameter, 2.3.3
COMPRESS clause, 10.2.4.2
compression, 10.2.4
compression advisor interface, 10.2.4.1
connecting
attributes, 5.6.3
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 parameter, 2.3.3
DB_FILE_MULTIBLOCK_READ_COUNT parameter, 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.1
wizard for creating, 4.3.1
See also flat files

F

fine-grained auditing
in data warehouses, 12.5
flat files
See also external tables

G

group properties, 5.7
GROUPING function, 7.1.3
GROUPING SETS function, 7.1.4
groups
connecting, 5.6.2
setting properties, 5.7

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 calculations
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.8
types of, 5.3.1
mapping operators, setting, 5.7
mappings
about, 5.1
creating, 5
defining, 5
materialized views, 10.2.2
memory, 2.2.1.2
memory management
parameters, 2.3.1
memory needed, 2.2.1.2
MERGE PARTITION operation, 9.3.1
MOVE PARTITION operation, 9.3.1

N

NOLOGGING
as a best practice, 11.2.4

O

offloading data
with rolling windows, 8.2
operator attributes, 5.6.3
operator properties
setting, 5.7
operators
connecting, 5.6
editing, 5.5
synchronizing with Repository objects, 5.8
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 parameter, 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 parameter, 2.3.3
PARALLEL_MAX_SERVERS parameter, 2.3.3
parameter
COMPATIBLE, 2.3.3
DB_BLOCK_SIZE, 2.3.3
DB_FILE_MULTIBLOCK_READ_COUNT, 2.3.3
OPTIMIZER_FEATURES_ENABLED, 2.3.3
PARALLEL_ADAPTIVE_MULTI_USER, 2.3.3
PARALLEL_MAX_SERVERS, 2.3.3
QUERY_REWRITE_ENABLED, 2.3.3
QUERY_REWRITE_INTEGRITY, 2.3.3
STAR_TRANSFORMATION_ENABLED, 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
setting, 5.7

Q

query rewrite, 2.3.3, 2.3.3, 4.4, 8.1.1, 10.2.2
QUERY_REWRITE_ENABLED parameter, 2.3.3
QUERY_REWRITE_INTEGRITY parameter, 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
refreshing
data warehouse, 8
resource consumption, 10.2
minimizing, 10.2
Resource Manager, 9.1.2
resource use, 10.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
sparsity, 7.2
SPLIT PARTITION operation, 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 parameter, 2.3.3
statistics
optimizer, 10.1.1
storage
optimizing, 9.3
synchronizing
operators and Repository objects, 5.8
system statistics, 10.1.1

T

table statistics, 10.1.1
table_compress clause, 10.2.4.2
tables
See also external tables
tools
for data warehouses, 1.4
transparent data encryption
in data warehouses, 12.6

U

UTLXPLAN.SQL script, 10.1.2

V

virtual private database
how it works, 12.3.1
in data warehouses, 12.3

W

wait events, 10.3.2
WITH clause, 7.3
wizards
Create External Table Wizard, 4.3.1