Indexed Views

External Article

SQL Server Indexed Views: The Basics

  • Article

Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style of SQL expression. They aren't there for reasons of performance, and so indexed views are designed to remedy this shortcoming. They're great in certain circumstances but they represent a trade-off, and they come with considerable 'small print'. Jes Borland explains.

2014-02-26

4,674 reads

Blogs

Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)

By

Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...

CosmosDB and Consistency

By

I was doing a little work with CosmosDB recently, and there were a few...

Daily Coping 17 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to reclaim space from a table

By WhiteLotus

Hi All I have 1 TB database and i cant shrink it as it...

SSIS SFTP

By water490

Hi everyone I am trying to create an SSIS package that will access an...

Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine

By CheBob

Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding Time

See possible answers