Effect of views on server performence | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Effect of views on server performence

Please tell me what are the advantages and disadvantages of views on server
performence? 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>