Views - advantage vs. disadvantage ?

Hello ,

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

Thank you
Who is Participating?
lluthienConnect With a Mentor Commented:

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 :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.