Beta Draft: 2012-02-07
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