🎁 New User? Get 20% off your first purchase with code NEWUSER20 · ⚡ Instant download · 🔒 Secure checkout Register Now →
Menu

Categories

Databases Intermediate

What is View?

A virtual table defined by a SQL query that provides a simplified or restricted view of data from one or more tables.

Views act as saved queries that can be referenced like tables. They simplify complex queries, restrict data access (showing only certain columns), and provide a stable interface even when underlying tables change.

Regular views execute the query each time they are accessed. Materialized views (PostgreSQL) store the result physically and must be refreshed, offering faster reads for complex aggregations at the cost of data freshness.

Related Terms

Connection Pool
A cache of database connections that can be reused, avoiding the overhead of creating new connections for each request.
Partitioning
A technique of dividing large database tables into smaller, more manageable segments while maintaining a single logical table.
ETL (Extract, Transform, Load)
A data pipeline process that extracts data from sources, transforms it into a suitable format, and loads it into a destination system.
Query Optimization
The process of improving database query performance through indexing, query rewriting, and schema design techniques.
Database Connection Pooling
A technique that maintains a cache of database connections for reuse, reducing the overhead of creating new connections.
Database Proxy
A middleware server that sits between applications and databases, providing connection pooling, load balancing, and query routing.
 View All Databases Terms →