Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is a view? Why we use it?




312
views
asked mar August 21, 2014 12:47 PM  

What is a view? Why we use it?


           

1 Answers



 
answered By Mswami   0  
VIEWS in DB2:

A view is a named specification of a result table. The specification is an SQL SELECT statement that is effectively executed whenever the view is referenced in an SQL statement. In other words, a view is a virtual table made up of data from base tables and other views, but not stored separately.

A view is a representation of data stored in one or more tables. A view is represented internally to DB2 by SQL statements, not by stored data. You can therefore define views using the same SQL statements that access data in base tables.

View Usage:

Each view must have a specific and logical use before it is created. Do not simply create a view for each base table. Views excel for the following six basic uses:

  • To provide row and/or column level security.
  • To ensure proper data derivation.
  • To ensure efficient access paths.
  • To mask complexity from the user.
  • To provide limited domain support.
  • To rename tables and/or columns.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -312
Number of Answers -1
Last updated
3 years and 3 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert