Materialized Views

GPTKB entity

Statements (49)
Predicate Object
gptkbp:instanceOf Database Object
gptkbp:canBe Dropped
Clustered
Disabled
Enabled
Indexed
Partitioned
Read-Only
Updatable
Automatically Refreshed
Dependent on Base Tables
Invalidated by DML
Logged
Manually Refreshed
Materialized on Commit
Materialized on Demand
Materialized on Schedule
Nonclustered
Recreated
Refreshed
Revalidated
Unlogged
Used in Query Rewrite
gptkbp:definedIn SQL Query
gptkbp:distinctFrom Views
https://www.w3.org/2000/01/rdf-schema#label Materialized Views
gptkbp:improves Read Performance
gptkbp:mayInclude Aggregated Data
Filtered Data
Joined Data
gptkbp:numberOfLocations Query Results
gptkbp:persists gptkb:Data
gptkbp:refreshType Complete
Incremental
gptkbp:requires Privileges
Storage Space
gptkbp:subject Staleness
gptkbp:supportedBy gptkb:MySQL
gptkb:Oracle_Database
gptkb:Microsoft_SQL_Server
gptkb:PostgreSQL
gptkbp:supports Query Performance Optimization
gptkbp:usedFor Reporting
Replication
Aggregation
Data Warehousing
gptkbp:usedIn gptkb:Database_Management_Systems
gptkbp:bfsParent gptkb:Database_Query_Processing
gptkbp:bfsLayer 7