Indexed views

[Kirby Grant]

When an indexed view is created, the data for the view is instantiated so
that an index can be created. But how much of that data is actually
instantiated? Every column or just the columns upon which indexes are
created?

[Erland Sommarskog]

Post by Kirby Grant
When an indexed view is created, the data for the view is instantiated so
that an index can be created. But how much of that data is actually
instantiated? Every column or just the columns upon which indexes are
created?

It's a clustered index. Thus the entire view is materialised.

[Kirby Grant]

Post by Erland Sommarskog

Post by Kirby Grant
When an indexed view is created, the data for the view is instantiated so
that an index can be created. But how much of that data is actually
instantiated? Every column or just the columns upon which indexes are
created?

It's a clustered index. Thus the entire view is materialised.

So then that must mean that when a row is inserted in the original table, it
is immediately replicated to the indexed view as well.

[Erland Sommarskog]

Post by Kirby Grant
So then that must mean that when a row is inserted in the original
table, it is immediately replicated to the indexed view as well.

Yes, atomically as part of the statement. Can be expensive.