Re: Views- Advantages and Disadvantages

Ashish Karalkar wrote:
> Thanks Brent for your replay,
>
>
> What about the Disadvantages, Performance issues?

As far as I'm aware, performance is the only real disadvantage.

I tend to break DB design into stages:

ER modelling to define the entities/relationships the DB needs to
store/represent
Normalize this to maximise data integrity & minimise duplication/redundancy
De-normalise to meet performance & access requirements.


In the latter stage, views are generally used, unless there are
performance restrictions,
when a de-normalised schema may be applied.

Cheers,

  Brent