Tuesday, March 19, 2013

What are the advantages of views?

  1. Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
  2. Hide data complexity.
  3. Simplify commands for the user.
  4. Present the data in a different perspective from that of the base table.
  5. Store complex queries.

No comments:

Post a Comment