Index

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

Numerics

3NF 1

A

about
- refresh statistics 1
accessing
- real-time materialized views 1
ADO, and IM column store 1
aggregates
- computability check 1
aggregation
- In-Memory Column Store 1
- VECTOR GROUP BY 1
alter analytic views 1
altering dimensions 1
alternate keys
- of an attribute dimension level 1
amortization
- calculating 1
analytic functions
- concepts 1
analytic processing
- materialized views 1
analytic views
- about 1
- alter or drop 1
- and attribute dimensions 1
- and materialized views 1
- APIs 1
- compilation states 1
- creating 1
- default hierarchy 1
- described 1
- example of creating 1
- example scripts 1
- hierarchical attributes 1
- hierarchies 1
- measures 1
- privileges for 1
- sharing with application containers 1
- tables for examples 1
application containers, sharing analytic views with 1
applications
- decision support systems (DSS) 1
approximate aggregations 1
approximate query processing 1
approximate values
- percentile functions 1
architecture
- data warehouse 1
attribute-clustered tables 1
attribute clustering
- adding to existing table 1
- advantages 1
- data dictionary views 1
- dropping 1
- guidelines 1
- methods 1
- modifying 1
- privileges 1
- types
  - interleaved ordering 1
  - linear ordering 1 , 2 , 3
- using hints for DML 1
attribute dimensions
- about 1
- attributes 1
- examples of creating 1
- level keys 1
- order of level members 1
- privileges for 1
attributes
- attribute dimension 1
- creating hierarchies using 1
automatic big table caching
- about 1

B

base measures
- examples of 1
bind variables
- with query rewrite 1
bitmap indexes
- nulls and 1
- on partitioned tables 1
- parallel query and DML 1
bitmap join indexes 1
B-tree indexes
- bitmap indexes versus 1
build methods 1
business intelligence
- queries 1
business rules
- violation of 1

C

calculated measures
- examples of 1
CAPTION classification 1
cardinality
- degree of 1
CASE expressions 1
cell referencing 1
classifications
- analytic view 1
columns
- cardinality 1
common joins 1
common tasks
- in data warehouses 1
compilation states
- of analytic views 1
complete refresh 1
complex queries
- snowflake schemas 1
composite
- columns 1
compression
- See data segment compression 1
concatenated groupings 1
concatenated ROLLUP 1
constraints
- foreign key 1
- RELY 1
- states 1
- unique 1
- view 1 , 2
- with partitioning 1
- with query rewrite 1
cost-based rewrite 1
CREATE DIMENSION statement 1
CREATE MATERIALIZED VIEW statement
- enabling query rewrite 1
creating
- materialized views with approximate queries 1
- real-time materialized views 1
- zone maps
  - with attribute clustering 1
CUBE clause
- partial 1
- when to use 1
cubes
- hierarchical 1
- materialized views 1
CUME_DIST function 1

D

data
- nonvolatile 1
- purging 1
- sufficiency check 1
- transformation 1
- transportation 1
database
- staging 1
data compression
- See data segment compression 1
data cubes
- hierarchical 1
data densification
- time series calculation 1
- with sparse data 1
data error handling
- using SQL 1
data marts 1
data rules
- violation of 1
data segment compression
- materialized views 1
- partitioning 1
data transformation
- multistage 1
- pipelined 1
data warehouse
- architectures 1
- dimension tables 1
- fact tables 1
- physical design 1
- refresh tips 1
data warehouses
- common tasks 1
- key characteristics of 1
date folding
- with query rewrite 1
DBMS_ADVISOR
- TUNE_MVIEW procedure 1
DBMS_ERROR package 1
DBMS_MVIEW package
- EXPLAIN_MVIEW procedure 1
- EXPLAIN_REWRITE procedure 1
DBMS_SYNC_REFRESH package 1
decision support systems (DSS)
- bitmap indexes 1
degree of cardinality 1
DENSE_RANK function 1
densification
- data 1
DESCRIPTION classification 1
design
- logical 1
- physical 1
DETERMINES
- clause of an attribute dimension level 1
dimension levels
- skipping 1
dimensions
- altering 1
- analyzing 1
- creating 1
- definition 1
- dimension tables 1
- dropping 1
- hierarchies 1
- multiple 1
- skipping levels 1
- validating 1
- with query rewrite 1
dimension tables
- normalized 1
displaying
- real-time materialized views 1
drilling down
- hierarchies 1
drop analytic views 1
DROP MATERIALIZED VIEW statement
- prebuilt tables 1
dropping
- dimensions 1
- materialized views 1
- zone maps 1

E

ELT 1
entity 1
error logging
- table 1
errors
- handling 1
ETL. See extraction, transformation, and loading (ETL) 1
ETL jobs
- monitoring 1
examples
- analytic views 1
- tables for analytic view 1
- zone maps
  - join pruning 1
  - partition and table scan pruning 1
EXCHANGE PARTITION statement 1
execution plans
- star transformations 1
EXPAND_GSET_TO_UNION hint 1 , 2
EXPLAIN_REWRITE procedure 1
EXPLAIN PLAN statement
- star transformations 1
exporting
- EXP utility 1
expression matching
- with query rewrite 1
external tables 1
extraction, transformation, and loading (ETL)
- overview 1
- process 1
extractions
- data files 1
- distributed operations 1
- full 1
- incremental 1
- OCI 1
- online 1
- overview 1
- physical 1
- Pro*C 1
- SQL*Plus 1

F

facts 1
fast refresh
- restrictions 1
- with UNION ALL 1
files
- ultralarge 1
filling gaps
- with data 1
FIRST_VALUE function 1
FIRST/LAST functions 1
foreign key
- constraints 1
- joins
  - snowflake schemas 1
FOR loops 1
frequent itemsets 1
functions
- analytic 1
- COUNT 1
- CUME_DIST 1
- DENSE_RANK 1
- FIRST_VALUE 1
- FIRST/LAST 1
- GROUP_ID 1
- GROUPING 1
- GROUPING_ID 1
- LAG/LEAD 1
- LAST_VALUE 1
- linear regression 1
- LISTAGG function 1
- NTH_VALUE 1
- RANK 1
- ranking 1
- RATIO_TO_REPORT 1
- REGR_INTERCEPT 1
- REGR_SLOPE 1
- reporting 1
- ROW_NUMBER 1
- WIDTH_BUCKET 1 , 2
- window 1
- windowing 1

G

GROUP_ID function 1
grouping
- compatibility check 1
- conditions 1
GROUPING_ID function 1
GROUPING_SETS expression 1
GROUPING function
- when to use 1

H

hierarchical attributes
- in a hierarchy 1
- MEMBER_UNIQUE_NAME 1
hierarchical cubes
- in SQL 1
hierarchies
- analytic view 1
- default 1
- examples of creating 1
- hierarchical attributes 1
- how used 1
- multiple 1
- overview 1
- privileges for 1
- rolling up and drilling down 1
- using any attribute 1
- validating data of 1
hints
- EXPAND_GSET_TO_UNION 1 , 2
- NOWRITE 1
- query rewrite 1 , 2
- REWRITE 1
- REWRITE_OR_ERROR 1
histograms
- creating with user-defined buckets 1
hypothetical rank 1

I

IM column store, managing contents 1
indexes
- bitmap indexes 1
- bitmap join 1
- B-tree 1
- cardinality 1
- nulls and 1
- partitioned tables 1
initialization parameters
- QUERY_REWRITE_ENABLED 1
In-Memory aggregation 1
In-Memory Column Store
- aggregation 1
in-memory expressions 1
in-memory virtual columns 1
integrity constraints 1
invalidating
- materialized views 1
itemsets
- frequent 1

J

join compatibility 1

K

key lookups 1
keys
- of an attribute dimension level 1

L

LAG/LEAD functions 1
LAST_VALUE function 1
level relationships
- purpose 1
levels
- order of members in 1
- types in an attribute dimension 1
levels in a dimension
- skipping 1
limiting rows returned 1
linear regression functions 1
LISTAGG function 1
local indexes 1 , 2
logging
- error 1
logical design 1
logs
- materialized views 1
lookup tables
- See dimension tables 1

M

managing
- refresh statistics 1
manual
- refresh 1
manual refresh
- with DBMS_MVIEW package 1
MATCH_RECOGNIZE clause 1
materialized view logs 1
materialized view refresh
- online table redefinition 1
materialized views
- aggregates 1
- altering 1
- analytic processing 1
- build methods 1
- checking status 1
- containing only joins 1
- creating 1
- cubes 1
- data segment compression 1
- delta joins 1
- dropping 1 , 2
- invalidating 1
- logs 1
- multiple 1
- naming 1
- nested 1
- ON STATEMENT refresh 1
- partition change tracking (PCT) 1
- partitioned tables 1
- partitioning 1
- prebuilt 1
- query rewrite
  - hints 1 , 2
  - matching join graphs 1
  - parameters 1
  - privileges 1
- real-time materialized views 1
- refresh dependent 1
- refreshing 1 , 2
- refreshing all 1
- registration 1
- restrictions 1
- rewrites
  - enabling 1
- schema design 1
- schema design guidelines 1
- security 1
- set operators 1
- storage characteristics 1
- types of 1
- uses for 1
- with VPD 1
measures
- analytic view 1
- base 1
- calculated 1
MERGE PARTITION operation 1
MERGE statement 1
MODEL clause
- cell referencing 1
- data flow 1
- keywords 1
- parallel execution 1
- rules 1
modeling
- logical design 1
- physical design 1
modifying
- zone maps 1
monitoring
- ETL jobs 1
- refresh 1
mortgage calculation 1
MOVE PARTITION operation 1
multiple hierarchies 1
multiple materialized views 1
MV_CAPABILITIES_TABLE table 1

N

nested materialized views
- refreshing 1
- restrictions 1
net present value
- calculating 1
nonvolatile data 1
NOREWRITE hint 1 , 2
NTH_VALUE function 1
nulls
- indexes and 1

O

ON COMMIT clause 1
ON DEMAND clause 1
online redefinition
- materialized views 1
ON STATEMENT clause 1
optimizations
- query rewrite
  - enabling 1
  - hints 1 , 2
  - matching join graphs 1
- query rewrites
  - privileges 1
optimizer
- with rewrite 1
ORDER BY clause
- in an attribute dimension level 1
outer joins
- with query rewrite 1
out-of-place refresh 1

P

packages
- DBMS_ADVISOR 1
- DBMS_DIMENSION 1
- DBMS_ERROR 1
- DBMS_ERRORLOG 1 , 2
- DBMS_MVIEW 1 , 2
- DBMS_SYNC_REFRESH 1
parallel DML
- bitmap indexes 1
parallel execution 1
parallelism 1
parallel query
- bitmap indexes 1
partition change tracking (PCT)
- refresh 1
- with Pmarkers 1
partitioned outer join 1
partitioned tables
- materialized views 1
partitioning
- materialized views 1
- prebuilt tables 1
partitions
- bitmap indexes 1
pattern matching
- keywords 1
patterns
- in SQL 1
percentile functions
- approximate results 1
physical design
- structures 1
pivoting
- operations 1
plans
- star transformations 1
Pmarkers
- with PCT 1
prebuilt materialized views 1
pruning
- examples 1 , 2
- using zone maps 1
purging data 1

Q

queries
- running with approximate functions 1
QUERY_REWRITE_ENABLED initialization parameter 1
query delta joins 1
query rewrite
- advanced 1
- checks made by 1
- controlling 1
- correctness 1
- date folding 1
- enabling 1 , 2
- hints 1 , 2
- matching join graphs 1
- materialized view with approximate queries 1
- methods 1
- parameters 1
- privileges 1
- real-time materialized views 1 , 2
- restrictions 1
- using equivalences 1
- using GROUP BY extensions 1
- using nested materialized views 1
- using PCT 1
- VPD 1
- when it occurs 1
- with bind variables 1
- with DBMS_MVIEW package 1
- with expression matching 1
- with inline views 1
- with partially stale materialized views 1
- with selfjoins 1
- with set operator materialized views 1
- with view constraints 1

R

range-partitioned table 1
RANK function 1
ranking functions 1
RATIO_TO_REPORT function 1
real-time materialized views
- accessing 1
- creating 1
- displaying 1
- for direct query access 1
- guidelines 1
- query rewrite 1 , 2
- restrictions 1
reference tables
- See dimension tables 1
refresh
- monitoring 1
- options 1
- out-of-place 1
- partition change tracking (PCT) 1
- scheduling 1
- synchronous 1
- with UNION ALL 1
refreshing
- materialized views 1
- materialized views based on approximate queries 1
- nested materialized views 1
- partitioning 1
- zone maps 1
refresh statistics
- about 1 , 2 , 3
- analyzing 1
- collecting 1 , 2
- data dictionary views 1
- managing 1
- modifying collection level 1
- modifying retention period 1
- purging 1
- retaining 1
- retention period 1
- setting defaults 1 , 2
- SQL statements 1
- understanding 1
- viewing basic 1
- viewing change data 1
- viewing detailed 1
- viewing settings 1
REGR_INTERCEPT function 1
REGR_R2 function 1
REGR_SLOPE function 1
RELY constraints 1
reporting functions 1
restrictions
- fast refresh 1
- nested materialized views 1
- query rewrite 1
result set 1
REWRITE_OR_ERROR hint 1
REWRITE hint 1 , 2
rewrites
- hints 1
- parameters 1
- privileges 1
- query optimizations
  - hints 1 , 2
  - matching join graphs 1
rolling up hierarchies 1
ROLLUP
- concatenated 1
- partial 1
- when to use 1
root level 1
row_limiting_clause clause 1
ROW_NUMBER function 1
rules
- in MODEL clause 1
- in SQL modeling 1
- order of evaluation 1

S

schemas
- 3NF 1
- design guidelines for materialized views 1
- snowflake 1
- star 1
set operators
- materialized views 1
simultaneous equations 1
skipping levels in a dimension 1
SKIP WHEN NULL clause 1
snowflake schemas
- complex queries 1
source systems 1
sparse data
- data densification 1
SPLIT PARTITION operation 1
SQL modeling
- cell referencing 1
- keywords 1
- order of evaluation 1
- performance 1
- rules 1
- rules and restrictions 1
staging
- areas 1
- databases 1
- files 1
star queries
- star transformation 1
star schemas
- dimensional model 1
star transformations
- restrictions 1
statistics 1
storage
- optimizing 1
summary management
- components 1
synchronous refresh 1
sync refresh 1

T

tables
- attribute-clustered 1
- detail tables 1
- dimension tables (lookup tables) 1
- external 1
- fact tables 1
tablespaces
- transportable 1 , 2 , 3
text match
- with query rewrite 1
Third Normal Form 1
time series calculations 1
timestamps 1
Top-N queries 1
transformations
- scenarios 1
- SQL*Loader 1
- SQL and PL/SQL 1
transportable tablespaces 1 , 2 , 3
transportation
- definition 1
- distributed operations 1
- flat files 1
triggers 1
types
- attribute clustering 1
- zone maps 1

U

ultralarge files 1
unique
- constraints 1
- identifier 1 , 2
update frequencies 1
UPDATE statement 1
update windows 1
UPSERT ALL statement 1
UPSERT statement 1

V

validating dimensions 1
validating hierarchy data 1
VECTOR GROUP BY
- aggregation 1
VECTOR GROUP BY aggregation
- optimizing star queries 1
view constraints 1 , 2
VPD
- and materialized views 1
- restrictions with materialized views 1

W

WIDTH_BUCKET function 1 , 2
window functions 1
windowing functions 1

Z

zone maps
- about 1
- about refreshing 1
- about staleness 1
- automatic refresh 1
- benefits 1
- compiling 1
- creating
  - with attribute clustering 1
- data dictionary views 1
- dropping 1
- maintaining 1
- maintenance 1
- modifying 1
- privileges 1
- pruning 1
- refreshing 1
- types 1
- usage for SQL statements 1
- usage for SQL workloads 1
- usage scenarios 1
- with attribute clustering 1