QuestionQ140

VerifiedDatabase Fundamentals

A business analyst queries the same small set of tables every quarter and does not want to write new SQL code each time. Which of the following would best meet the business analyst’s needs while allowing the database administrator to optimize disk space?

Explanation

A view is a named, reusable virtual table defined by a query. A standard non-indexed view stores the query definition rather than a separate persisted copy of its result data, so it avoids consuming extra disk space while allowing recurring access to the same underlying tables without rewriting the query.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!