NoExpend Table Hint in SQL Server

The noexpend table hint is specifically related to how the query optimizer handles indexed view. It prevents SQL server from expending view when we are querying them. By default, SQL Server expands indexed view meaning it treats them like regular view by reprocessing the underlaying tables. This hint force SQL server to use the indexed view directly improving query performance.

Syntex

Select * from view with (noexpend)

It improves performance by directly reading pre computed data. It is useful for complex aggregations and large dataset. It only works on indexed view.