Re: Views- Advantages and Disadvantages

> On 5/9/07, Ashish Karalkar <ashish.karalkar@info-spectrum.com> wrote:
>
> Hello All,
> Can anybody please point me to Advantages and Disadvantages
> of using view

Hi Ashish,

There are several, but they are generally about implementing a more user
friendly database from a well normalised structure.


You can use views to do any or all of:

 act as a filter on fields or records which can be accessed by given users,

 act as a stored query to avoid writing a commonly used SQL,

 aggregate normalised tables into a single virtual table, so that access
 does not require as complex a join, thus it can hide the complexity of the
 database structure from applications or users.

An example use is to have a view which provides only the current version
of data from a database which stores multiple versions of the data.

Cheers,

  Brent Wood