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
|