The SqlHints type exposes the following members.
Specifies that any indexed views are not expanded to access underlying tables when the query optimizer processes the query. The query optimizer treats the view like a table with clustered index. NOEXPAND applies only to indexed views.
Specifies that the query can read the uncommitted data and ignores the locks.