Views -   advantage vs. disadvantage ?

Posted on 2005-05-08
Last Modified: 2012-06-22
Hello ,

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

Thank you
Question by:asi
    LVL 11

    Accepted 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?
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>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.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Award points to lluthien.
    LVL 11

    Expert Comment

    since there are no responses from the asker any more..
    i agree :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now