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. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *