thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

View

A named stored query that behaves like a virtual table; it stores no data and runs its query when referenced.

Definition

Views simplify complex joins, present consistent business logic and restrict access by exposing only selected rows or columns. Updatable views must meet vendor rules. Performance is the same as running the underlying query.

Example

CREATE VIEW vActiveCustomers AS SELECT CustomerID, Name FROM Customers WHERE IsActive = 1;

Exam tip

A standard view stores the query, not the results. If results must be precomputed for speed, choose a materialized view.

Related terms