What are some common techniques used in denormalization?
- Indexing
- Materialized Views
- Normalization
- Partitioning
Materialized Views are a common technique used in denormalization. They are precomputed views stored on disk, which can greatly improve query performance by reducing the need for joins and calculations.
Loading...
Related Quiz
- Performance tuning in DB2 involves leveraging various ________ features.
- Weak entities in an ERD depend on the existence of ________ entities.
- ________ transactions are handled concurrently in DB2.
- Which recovery strategy in DB2 involves restoring a database to the last consistent state before failure?
- DB2 administrators can use ________ to gather real-time information about database activity.