What is NOEXPAND in SQL?

Hi,

NOEXPAND tells query optimizer to use indexes on views.

Ex:

select * from INDEXED_TEST_VIEW with (NOEXPAND)

forces sql query optimizer to use indexes on views, with out looking for its underlying tables.