Index
A
- about
- refresh statistics 9.1
- accessing
- real-time materialized views 6.7.1.2
- ADO, and IM column store 2.5.3
- aggregates 5.2.1, 12.9.5
- computability check 12.1.3.4
- aggregation
- alter analytic views 25.9
- altering dimensions 10.6
- alternate keys
- of an attribute dimension level 26.4
- amortization
- calculating 23.5.6
- analytic functions 23.3.5
- concepts 20.1
- analytic processing
- materialized views 6.2
- analytic views
- about 27.1
- alter or drop 25.9
- and materialized views 6.2.1
- APIs 25.4
- compilation states 25.5
- creating 27.3
- described 25.1
- example of creating 25.10.4
- example of filtering facts 27.6.1, 27.6.3
- example of using added measures 27.6.2, 27.6.3
- example scripts 25.10
- hierarchical attributes 26.2
- hierarchies 26.1
- measures 27.2
- privileges for 25.3
- sharing with application containers 25.8
- tables for examples 25.10.1
- application containers, sharing analytic views with 25.8
- applications
- decision support systems (DSS) 4.1.2
- APPROX_COUNT function 4.7
- APPROX_RANK function 20.2.1.2
- APPROX_SUM function 4.7
- approximate aggregations 20.3.1
- approximate query processing 4.6
- approximate top-n query processing 4.7
- approximate values
- percentile functions 20.3.4.5
- architecture
- data warehouse 1.4
- attribute-clustered tables 14.1
- attribute clustering 14.1
- attribute dimensions
- attributes 2.2
- automatic big table caching
- about 2.6
B
C
- calculated measures 27.2
- CAPTION classification 25.7
- cardinality
- degree of 4.1.3
- CASE expressions 20.8.3
- cell referencing 23.2.4
- classifications
- analytic view 25.7
- columns
- cardinality 4.1.3
- common joins 12.1.3.1.1
- common tasks
- in data warehouses 1.3
- compilation states
- of analytic views 25.5
- complete refresh 7.1.1
- complex queries
- snowflake schemas 2.4.3
- composite
- columns 21.6
- compression
- See data segment compression 5.3.4
- concatenated groupings 21.7
- concatenated ROLLUP 21.10.1
- constraints 4.2, 10.4
- cost-based rewrite 12.1.1
- CREATE DIMENSION statement 10.2
- CREATE MATERIALIZED VIEW statement 5.3
- enabling query rewrite 11.2.1
- creating
- CUBE clause 21.3
- cubes
- CUME_DIST function 20.2.1.4
D
- data
- database
- staging 5.1
- data compression 4.4.1
- See data segment compression 5.3.4
- data cubes
- hierarchical 21.7.1
- data densification 20.6
- data error handling
- using SQL 19.4.2.1
- data marts 1.4.3
- data rules
- violation of 19.4.2
- data segment compression 3.2.1.2
- data transformation
- data warehouse 5.1
- data warehouses
- date folding
- with query rewrite 12.3.5
- DBMS_ADVISOR
- TUNE_MVIEW procedure 5.3.6
- DBMS_ERROR package 19.4.2.3
- DBMS_MVIEW package 7.1.7
- DBMS_SYNC_REFRESH package 8
- decision support systems (DSS)
- bitmap indexes 4.1.2
- degree of cardinality 4.1.3
- DENSE_RANK function 20.2.1.1
- densification
- data 20.6
- DESCRIPTION classification 25.7
- design
- DETERMINES
- clause of an attribute dimension level 26.5
- dimension levels
- skipping 10.2
- dimensions 3.2.6, 10.1, 10.4
- dimension tables 5.1.6
- normalized 10.2.3
- displaying
- real-time materialized views 6.7.7
- drilling down 10.1
- hierarchies 10.1
- drop analytic views 25.9
- DROP MATERIALIZED VIEW statement
- prebuilt tables 5.7
- dropping
E
- ELT 16.1
- entity 2.2
- error logging 19.4
- table 19.4.2.3
- errors
- handling 19.4
- ETL. See extraction, transformation, and loading (ETL) 16.1
- ETL jobs
- monitoring 19.1.3
- examples
- EXCHANGE PARTITION statement 4.2.2.6
- execution plans
- star transformations 4.5.2.2
- EXPAND_GSET_TO_UNION hint 12.3.9.2, 12.9.10.4
- EXPLAIN_REWRITE procedure 12.8.2
- EXPLAIN PLAN statement 12.8.1
- star transformations 4.5.2.2
- exporting
- EXP utility 17.3.1.3
- expression matching
- with query rewrite 12.3.11
- external tables 19.2.2
- extraction, transformation, and loading (ETL) 16.1
- extractions
F
- facts 10.1
- fast refresh 7.1.2
- FETCH
- row_limiting_clause 20.9
- files
- ultralarge 3.2.1.1
- filling gaps
- with data 20.6.6
- FIRST_VALUE function 20.2.5.1
- FIRST/LAST functions 20.3.3
- foreign key
- FOR loops 23.3.1
- frequent itemsets 20.8.4
- functions
- analytic 23.3.5
- APPROX_COUNT 4.7
- APPROX_RANK 20.2.1.2
- APPROX_SUM 4.7
- COUNT 4.1.1.1
- CUME_DIST 20.2.1.4
- DENSE_RANK 20.2.1.1
- FIRST_VALUE 20.2.5.1
- FIRST/LAST 20.3.3
- GROUP_ID 21.4.4
- GROUPING 21.4
- GROUPING_ID 21.4.3
- LAG/LEAD 20.2.4
- LAST_VALUE 20.2.5.1
- linear regression 20.3.6
- LISTAGG function 20.3.2
- NTH_VALUE 20.2.5.2
- RANK 20.2.1.1
- ranking 20.2.1
- RATIO_TO_REPORT 20.2.3.1
- REGR_INTERCEPT 20.3.6.3
- REGR_SLOPE 20.3.6.3
- reporting 20.2.3
- ROW_NUMBER 20.2.1.7
- WIDTH_BUCKET 20.8.1, 20.8.1.1
- window 23.3.5
- windowing 20.2.2
H
I
- IM column store, managing contents 2.5.3
- indexes
- initialization parameters
- QUERY_REWRITE_ENABLED 11.2.1
- In-Memory aggregation 21.8.6
- In-Memory Column Store
- aggregation 21.8.6
- in-memory expressions 2.5.1
- in-memory virtual columns 2.5.2
- integrity constraints 4.2
- invalidating
- materialized views 6.5
- itemsets
- frequent 20.8.4
L
- LAG/LEAD functions 20.2.4
- LAST_VALUE function 20.2.5.1
- level relationships 3.2.6.1
- purpose 3.2.6.1.2
- levels 3.2.6, 3.2.6.1.1
- levels in a dimension
- skipping 10.2
- limiting rows returned 20.9
- linear regression functions 20.3.6
- LISTAGG function 20.3.2
- local indexes 4.1.1.2, 4.1.2
- logging
- error 19.4
- logical design 3.1
- logs
- materialized views 5.4
- lookup tables
- See dimension tables 5.1.6
M
- managing
- refresh statistics 9.2
- manual
- refresh 7.1.7
- manual refresh
- with DBMS_MVIEW package 7.1.7
- MATCH_RECOGNIZE clause 22
- materialized view logs 5.4
- materialized view refresh
- online table redefinition 7.1.14
- materialized views
- aggregates 5.2.1
- altering 6.6
- analytic processing 6.2
- based on hybrid partitioned tables 5.3.2
- build methods 5.3.5
- checking status 7.1.17
- containing only joins 5.2.2
- creating 5.3
- cubes 6.2.2
- data segment compression 5.3.4
- delta joins 12.1.3.1.3
- dropping 5.7, 5.9
- invalidating 6.5
- logs 17.2.3
- multiple 12.2.8
- naming 5.3.3
- nested 5.2.3
- ON STATEMENT refresh 7.1.6
- partition change tracking (PCT) 6.1.1
- partitioned tables 7.3
- partitioning 6.1
- prebuilt 5.3
- query rewrite
- real-time materialized views 6.7.1
- refresh dependent 7.1.10
- refreshing 5.3.8.2, 7.1
- refreshing all 7.1.9
- registration 5.7
- restrictions 5.3.7.1
- rewrites
- enabling 11.2.1
- schema design 5.1.7
- schema design guidelines 5.1.7
- security 6.4
- set operators 6.2.5
- storage characteristics 5.3.4
- types of 5.2
- uses for 5.1
- with VPD 6.4.1
- materialized viewsCOUNT(DISTINCT) 5.6
- measures 5.1.6
- MERGE PARTITION operation 4.4.1
- MERGE statement 7.6.1
- MODEL clause 23.1
- modeling
- modifying
- zone maps 15.2.5
- monitoring
- mortgage calculation 23.5.6
- MOVE PARTITION operation 4.4.1
- multiple hierarchies 10.2.2
- multiple materialized views 12.2.8
- MV_CAPABILITIES_TABLE table 5.10.1.2
O
- OFFSET
- row_limiting_clause 20.9
- ON COMMIT clause 5.3.8.1
- ON DEMAND clause 5.3.8.1
- online redefinition
- materialized views 7.1.14
- ON STATEMENT clause 5.3.8.1
- optimizations
- optimizer
- with rewrite 11.1.1
- ORDER BY clause 5.3.9
- in an attribute dimension level 26.3
- outer joins
- with query rewrite 12.9.3
- out-of-place refresh 7.1.4
P
- packages
- parallel DML
- bitmap indexes 4.1.2
- parallel execution 4.3
- parallelism 4.3
- parallel query
- bitmap indexes 4.1.2
- partition change tracking (PCT) 6.1.1, 7.3.1, 12.2.7
- partitioned outer join 20.6
- partitioned tables
- materialized views 7.3
- partitioning 17.2.3
- partitions
- bitmap indexes 4.1.1.2
- pattern matching 22
- keywords 22.2.2
- patterns
- in SQL 22
- percentile functions
- approximate results 20.3.4.5
- physical design 3.1
- structures 3.2.1
- pivoting 19.5.4, 20.4
- operations 20.4
- plans
- star transformations 4.5.2.2
- Pmarkers
- with PCT 12.2.7.4
- prebuilt materialized views 5.3
- pruning
- purging data 7.6.3
Q
- queries
- running with approximate functions 4.6.1
- QUERY_REWRITE_ENABLED initialization parameter 11.2.1
- query delta joins 12.1.3.1.2
- query rewrite
- advanced 12.4
- checks made by 12.1.3
- controlling 11.2.3
- correctness 11.2.4
- date folding 12.3.5
- enabling 11.2, 11.2.1
- hints 11.2.1, 12.9.10.1
- matching join graphs 5.3.7
- materialized view with approximate queries 12.6
- methods 12.1
- parameters 11.2.2
- privileges 11.2.5
- real-time materialized views 6.7.4, 6.7.5
- restrictions 5.3.7.2
- using equivalences 12.4
- using GROUP BY extensions 12.3.9.1
- using nested materialized views 12.3.1
- using PCT 12.2.7
- VPD 6.4.1.1
- when it occurs 11.1.2
- with bind variables 12.3.12
- with DBMS_MVIEW package 12.8.2
- with expression matching 12.3.11
- with inline views 12.3.2
- with partially stale materialized views 12.3.11.1
- with selfjoins 12.3.4
- with set operator materialized views 12.3.8
- with view constraints 12.3.6
R
- range-partitioned table 4.4.1
- RANK function 20.2.1.1
- ranking functions 20.2.1
- RATIO_TO_REPORT function 20.2.3.1
- real-time materialized views 6.7.1
- reference tables
- See dimension tables 5.1.6
- refresh
- refreshing
- refresh statistics
- about 9.1, 9.4.1, 9.5.1
- analyzing 9.9
- collecting 9.4.1, 9.4.2
- data dictionary views 9.3
- managing 9.2
- modifying collection level 9.4.3
- modifying retention period 9.5.3
- purging 9.7
- retaining 9.5.1
- retention period 9.5.2
- setting defaults 9.4.2, 9.5.2
- SQL statements 9.8.4
- understanding 9.9
- viewing basic 9.8.1
- viewing change data 9.8.3
- viewing detailed 9.8.2
- viewing settings 9.6
- REGR_INTERCEPT function 20.3.6.3
- REGR_R2 function 20.3.6.4
- REGR_SLOPE function 20.3.6.3
- RELY constraints 4.2.2.3
- reporting functions 20.2.3
- restrictions
- result set 4.5.2
- REWRITE_OR_ERROR hint 12.9.10.2
- REWRITE hint 11.2.1, 12.9.10.1
- rewrites
- rolling up hierarchies 10.1
- ROLLUP 21.2
- root level 3.2.6.1.1
- row_limiting_clause clause 20.9
- ROW_NUMBER function 20.2.1.7
- rules
S
- schemas
- set operators
- materialized views 6.2.5
- simultaneous equations 23.5.4
- skipping levels in a dimension 10.2
- SKIP WHEN NULL clause 10.2
- snowflake schemas 2.4.3
- complex queries 2.4.3
- source systems 17.1
- sparse data
- data densification 20.6.2
- SPLIT PARTITION operation 4.4.1
- SQL modeling 23.1
- staging
- star queries
- star transformation 4.5.2
- star schemas
- dimensional model 2.4.1
- star transformations 4.5.2
- restrictions 4.5.2.6
- statistics 12.9.9
- storage
- optimizing 4.4
- summary management
- components 5.1.5
- synchronous refresh 8
- sync refresh 8
T
Z
- zone maps 15.1
- about 15.1
- about refreshing 15.3.2
- about staleness 15.3.1
- automatic refresh 15.1.6.2
- benefits 15.1.4
- compiling 15.2.7
- creating 15.2.2.2
- with attribute clustering 15.2.2.1
- data dictionary views 15.5
- dropping 15.2.6
- maintaining 15.2.9
- maintenance 15.1.6.1
- modifying 15.2.5
- privileges 15.2.1
- pruning 15.4
- refreshing 15.3.3
- types 15.1.3
- usage for SQL statements 15.2.8.2
- usage for SQL workloads 15.2.8.1
- usage scenarios 15.1.5
- with attribute clustering 15.1.2