• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5462
  • Last Modified:

Views - advantage vs. disadvantage ?

Hello ,

What is the advantages and disadvantages of using view regarding maintain ? spead ? large / small  DB ? etc....

Thank you
  • 2
  • 2
1 Solution

a view is a logical gathering of data from multiple tables.
you can use views to gather data into a certain context.

a view is 'calculated' everytime you open it,
so the speed depends on the query you use for the view.

it does not store real data itself.
so regarding db size, a view doesnt change much.

it is really depending on the situation,
wether you wish to use it or not.

an advantage is that you can easily use a view to create new information out of existing data,
without changing the (legacy) database structure.

a disadvantage is that it will have to do the query anew everytime it is opened.

does this help?
Anthony PerkinsCommented:
>>What is the advantages and disadvantages of using view <<
That is like asking:  What are the advantages and disadvantages of using a hammer?  Without a comparison it is meaningless. A View is a tool, just like stored procedures, triggers, etc.
Anthony PerkinsCommented:
Award points to lluthien.
since there are no responses from the asker any more..
i agree :)

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now