© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_10

10. Views

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Views represent virtual tables defined by underlying queries, and they add another layer of abstraction to the system. Views hide implementation details and can present queries with complex joins and aggregation as a single table. Moreover, views can be used to restrict access to the data and provide just a subset of the rows and columns to users.

There are two different kinds of views available in SQL Server: regular views and indexed (materialized) views. Let’s look at them in detail.

Views

Regular views are just the metadata. When you reference a view in your queries, SQL Server replaces it ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.