March 16, 2005 at 7:24 am
I'd like to include the maxdop hint within some views, the sql is quite convoluted and I can get big gains by using maxdop 1 or 2 but I can't seem to be able to add this hint to the view, is this correct ?
Thanks.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 21, 2005 at 8:00 am
This was removed by the editor as SPAM
March 30, 2005 at 2:11 pm
Maybe I'm goofy, but I thought the hints were on indexes, etc. MAXDOP would have to be on the executed query - i.e. SELECT col1, col2, col3 FROM (view) OPTION (maxdop 1)
June 23, 2005 at 10:19 am
Did you ever find a solution to this problem. I am having the same problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply