Large View

Posted on 2008-11-03
Last Modified: 2010-03-20

I have a large view 1,000,000 plus rows.  Is there a better way to store this data.  The view contains calculations and the data can change....


Question by:nutnut
    LVL 17

    Expert Comment

    A view doesn't store the data. It simply pulls out the data from the underlying tables in a fashion or manner that the view creator wanted to see it.

    Does the view do what you want? it is overkill?

    You can always modify the view to return fewer records based on a condition that you might understand.

    Or add a view that limits the result set in the same manner.

    Any other information you can provide would help us to help you.
    LVL 60

    Accepted Solution

    A view can store data if it is indexed.

    Really though, a view is just a stored query, it is a "VIEW" into seeing the data, typically doesn't store any itself (unless it is indexed)

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now