What is the primary purpose of creating views in DB2?
- Define security constraints
- Optimize query performance
- Provide data redundancy
- Simplify complex queries
Views in DB2 are primarily used to simplify complex queries by presenting a subset of data from one or more tables. They can hide the complexity of underlying table structures and provide a simplified interface for users to access data.
Loading...
Related Quiz
- Which DB2 feature allows for the customization of XML output?
- What is the primary purpose of data compression in DB2?
- What does DB2 offer in terms of scalability?
- When using the SUM() function in DB2, NULL values in the column are ________ in the calculation.
- DB2 implements optimistic concurrency control by ________.