What is a view and when would you use one?

SQL indexes, transactions and performance · Freshers and experienced

Model answer

A saved query that behaves like a virtual table. Use views to simplify complex queries, hide columns for security, or provide a stable interface when the underlying tables change. A regular view does not store data and is not faster by itself.

Learn this topic

Indexes and Faster Queries: EXPLAIN for Beginners in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is an index and why use it?
• What is a transaction?
• What does ACID mean?
• What is the difference between a clustered and a non-clustered index?
• What is a composite index and why does column order matter?
• How do you check how a query runs?