Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Views

 

Benefits of using views

Views let you tailor access to data in the database. Tailoring access serves several purposes:

  • Efficient resource use   Regular views do not require additional storage space for data; they are recomputed each time you invoke them. Materialized views require disk space, but do not need to be recomputed each time they are invoked. Materialized views can improve response time in environments where the database is large, and the database server processes frequent, repetitive requests to join the same tables.

  • Improved security   It allows access to only the information that is relevant.

  • Improved usability   It presents users and application developers with data in a more easily understood form than in the base tables.

  • Improved consistency   It centralizes the definition of common queries in the database.