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

Large View


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....


1 Solution
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
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.
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

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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