We solve complex problems of data modeling and develop tools and solutions to let business perform best through data analysis.

Forum

 
ForumForumDiscussionsDiscussionsSQLBI Methodolo...SQLBI Methodolo...Recompile Hint?Recompile Hint?
Previous Previous
 
Next Next
New Post
 7/20/2009 6:41 PM
 
kskistad
No Ranking

Joined: 9/16/2008
Posts: 4
I apologize if this has been asked before, but in your paper, you mention using the OPTION (RECOMPILE) in your views so they get compiled on every execution, but according to BOL, you cannot use the OPTION clause in a SELECT statement within a view (http://msdn.microsoft.com/en-us/library/ms187956.aspx)Or am I missing something?
New Post
 7/20/2009 7:12 PM
 
alberto.ferrari
5th Level Poster

Joined: 4/24/2006
Posts: 114

You are definitely right. I found this problem when working with stored procedures and, when writing the paper, I made some confusion.

Views are expanded before the generation of the execution plan and so they do not suffer from the problem highlighted in the paper.

Thanks for the useful correction.

Alberto

 Page 1 of 1
Previous Previous
 
Next Next
ForumForumDiscussionsDiscussionsSQLBI Methodolo...SQLBI Methodolo...Recompile Hint?Recompile Hint?