Do table hints in the view definition affect the view?

Question

We know that we can use table hints when selecting records in our own queries.

my question is:

when we create a view and use table hints such as "Nolock", "Holdlock", etc ... and then save the view in SQL server, does the table hint we used affect the view?

gbn · Answer 1 · 2009-07-19T13:43:34.020

2

Yes. Any hints in the view affect how it's used.

Note: a table hint on a view propagates as well

SELECT * FROM MyView WITH (NOLOCK)-- hint applies to base tables too

edited Jul 19 '09 at 13:43

answered Jul 19 '09 at 13:33

gbn

422,506
82
585
676

even if we have gathered records from other server and other DB? – odiseh Jul 19 '09 at 14:31
With linked servers etc? Sorry, I don't know. Other DBs on the same server: probably yes – gbn Jul 19 '09 at 15:02

Do table hints in the view definition affect the view?

1 Answers1