February 24, 2007 at 12:23 am
1) We have SQL Server 2005 on windows 2003 server.
2) We have views on tables without any READ (UNCOMMITTED) table hint.
3) In our stored procs, we use only these views in all queries & READ (UNCOMMITTED)
is allowed for them as well.
4) Will it have effect? Will this hint percolate to all the tables in joins in FROM clause
of the view definition? If not do we place this hint against all the tables in all the views
as well?
5) OR is it better to just have this table hint against all the tables themselves in the
view definition itself?
February 27, 2007 at 8:00 am
This was removed by the editor as SPAM
May 22, 2008 at 8:24 am
The READUNCOMMITTED will percolate down to all select statements against the view. You don't need to be explicit.
However - be careful you have not set OPTION READCOMMITTED at the top of statements. I did that and found SQL 2005 was locking despite the READUNCOMMITTED depending - I believe - on the index used in the query of a table I was joining to the view. I got around that by specifying READUNCOMMITTED against the table (but no hint against the view).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply