SQL Server Performance Forum – Threads Archive
Effect of views on server performence
Please tell me what are the advantages and disadvantages of views on serverperformence? Is it good to make views instead of write complex query?
Is view slower than query. anand
Welcome here! [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Your question is a bit broad and you might want to look around the site for some answers. <br /><br />There is no absolute answer to your question. VIEWs serve a different purpose.<br /><br />–<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
]]>