Re: Views- Advantages and Disadvantages

> On 5/9/07, Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)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