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 24.8
- altering dimensions 10.6
- alternate keys
- of an attribute dimension level 25.4
- amortization
- calculating 22.5.6
- analytic functions 22.3.5
- concepts 19.1
- analytic processing
- materialized views 6.2
- analytic views
- about 26.1
- alter or drop 24.8
- and materialized views 6.2.1
- APIs 24.3
- compilation states 24.4
- creating 26.3
- described 24.1
- example of creating 24.9.4
- example of filtering facts 26.6.1, 26.6.3
- example of using added measures 26.6.2, 26.6.3
- example scripts 24.9
- hierarchical attributes 25.2
- hierarchies 25.1
- measures 26.2
- privileges for 24.2
- sharing with application containers 24.7
- tables for examples 24.9.1
- application containers, sharing analytic views with 24.7
- applications
- decision support systems (DSS) 4.1.2
- APPROX_COUNT function 4.7
- APPROX_RANK function 19.2.1.2
- APPROX_SUM function 4.7
- approximate aggregations 19.3.1
- approximate query processing 4.6
- approximate top-n query processing 4.7
- approximate values
- percentile functions 19.3.4.5
- architecture
- data warehouse 1.4
- attribute-clustered tables 13.1
- attribute clustering 13.1
- attribute dimensions
- attributes 2.2
- automatic big table caching
- about 2.6
B
C
- calculated measures 26.2
- CAPTION classification 24.6
- cardinality
- degree of 4.1.3
- CASE expressions 19.8.3
- cell referencing 22.2.4
- classifications
- analytic view 24.6
- columns
- cardinality 4.1.3
- common joins 12.1.3.1.1
- common tasks
- in data warehouses 1.3
- compilation states
- of analytic views 24.4
- complete refresh 7.1.1
- complex queries
- snowflake schemas 2.4.3
- composite
- columns 20.6
- compression
- See data segment compression 5.3.4
- concatenated groupings 20.7
- concatenated ROLLUP 20.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 20.3
- cubes
- CUME_DIST function 19.2.1.4
D
- data
- database
- staging 5.1
- data compression 4.4.1
- See data segment compression 5.3.4
- data cubes
- hierarchical 20.7.1
- data densification 19.6
- data error handling
- using SQL 18.4.2.1
- data marts 1.4.3
- data rules
- violation of 18.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 18.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 19.2.1.1
- densification
- data 19.6
- DESCRIPTION classification 24.6
- design
- DETERMINES
- clause of an attribute dimension level 25.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 24.8
- DROP MATERIALIZED VIEW statement
- prebuilt tables 5.7
- dropping
E
- ELT 15.1
- entity 2.2
- error logging 18.4
- table 18.4.2.3
- errors
- handling 18.4
- ETL. See extraction, transformation, and loading (ETL) 15.1
- ETL jobs
- monitoring 18.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 16.3.1.3
- expression matching
- with query rewrite 12.3.11
- external tables 18.2.2
- extraction, transformation, and loading (ETL) 15.1
- extractions
F
- facts 10.1
- fast refresh 7.1.2
- FETCH
- row_limiting_clause 19.9
- files
- ultralarge 3.2.1.1
- filling gaps
- with data 19.6.6
- FIRST_VALUE function 19.2.5.1
- FIRST/LAST functions 19.3.3
- foreign key
- FOR loops 22.3.1
- frequent itemsets 19.8.4
- functions
- analytic 22.3.5
- APPROX_COUNT 4.7
- APPROX_RANK 19.2.1.2
- APPROX_SUM 4.7
- COUNT 4.1.1.1
- CUME_DIST 19.2.1.4
- DENSE_RANK 19.2.1.1
- FIRST_VALUE 19.2.5.1
- FIRST/LAST 19.3.3
- GROUP_ID 20.4.4
- GROUPING 20.4
- GROUPING_ID 20.4.3
- LAG/LEAD 19.2.4
- LAST_VALUE 19.2.5.1
- linear regression 19.3.6
- LISTAGG function 19.3.2
- NTH_VALUE 19.2.5.2
- RANK 19.2.1.1
- ranking 19.2.1
- RATIO_TO_REPORT 19.2.3.1
- REGR_INTERCEPT 19.3.6.3
- REGR_SLOPE 19.3.6.3
- reporting 19.2.3
- ROW_NUMBER 19.2.1.7
- WIDTH_BUCKET 19.8.1, 19.8.1.1
- window 22.3.5
- windowing 19.2.2
H
I
- IM column store, managing contents 2.5.3
- indexes
- initialization parameters
- QUERY_REWRITE_ENABLED 11.2.1
- In-Memory aggregation 20.8.6
- In-Memory Column Store
- aggregation 20.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 19.8.4
L
- LAG/LEAD functions 19.2.4
- LAST_VALUE function 19.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 19.9
- linear regression functions 19.3.6
- LISTAGG function 19.3.2
- local indexes 4.1.1.2, 4.1.2
- logging
- error 18.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 21
- 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 16.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 22.1
- modeling
- modifying
- zone maps 14.2.3
- monitoring
- mortgage calculation 22.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 19.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 25.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 19.6
- partitioned tables
- materialized views 7.3
- partitioning 16.2.3
- partitions
- bitmap indexes 4.1.1.2
- pattern matching 21
- keywords 21.2.2
- patterns
- in SQL 21
- percentile functions
- approximate results 19.3.4.5
- physical design 3.1
- structures 3.2.1
- pivoting 18.5.4, 19.4
- operations 19.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 19.2.1.1
- ranking functions 19.2.1
- RATIO_TO_REPORT function 19.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 19.3.6.3
- REGR_R2 function 19.3.6.4
- REGR_SLOPE function 19.3.6.3
- RELY constraints 4.2.2.3
- reporting functions 19.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 20.2
- root level 3.2.6.1.1
- row_limiting_clause clause 19.9
- ROW_NUMBER function 19.2.1.7
- rules
S
- schemas
- set operators
- materialized views 6.2.5
- simultaneous equations 22.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 16.1
- sparse data
- data densification 19.6.2
- SPLIT PARTITION operation 4.4.1
- SQL modeling 22.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 14.1
- about 14.1
- about refreshing 14.3.2
- about staleness 14.3.1
- automatic refresh 14.1.6.2
- benefits 14.1.4
- compiling 14.2.5
- creating 14.2.2.2
- with attribute clustering 14.2.2.1
- data dictionary views 14.5
- dropping 14.2.4
- maintaining 14.2.7
- maintenance 14.1.6.1
- modifying 14.2.3
- privileges 14.2.1
- pruning 14.4
- refreshing 14.3.3
- types 14.1.3
- usage for SQL statements 14.2.6.2
- usage for SQL workloads 14.2.6.1
- usage scenarios 14.1.5
- with attribute clustering 14.1.2