Wednesday, September 3, 2014

Views in SQL


Views are precompiled SQL statements, which can involve more thatn one table. The SQL developer / user can refer to all the columns in the views as being referred to a single table.

Trivia on Views

  • Can use joins to get columns from more than one table.
  • Can hide columns form the user.
  • Can act as aggregated tables where there are complex calculations performed to get the column values.
  • Takes lesser tome to execute, since the statement is precompiled.
  • Does occupy a little memory but does not store the records as in table.
  • Views can be updated, if there is one to one relationship between the rows in the view and tables.
 
 
Tags: Views in SQL, Views, Trivia on Views,