What are indexed views and how do they work internally?

Indexed views store precomputed query results physically like a table.

An indexed view persists aggregated or joined results, improving read performance. SQL Server maintains it automatically on base table changes, but writes become more expensive.