SQL Server Performance Forum – Threads Archive
are Views stored in data base physically or logicare Views stored in data base physically or logically?. is view a virtual table?
UNIQUE CLUSTERED INDEX used to index the view? Alagappapillai
There is no point in repeating the definition of view here. I ‘request’ u to refer ‘views [SQL Server]’ in BOL, it will clear all doubts. If u r new to sql; BOL(Books Online) is the Bible of SQL Server. You can install it from CD or from Microsoft Site.
.. updated BOL is better than installing from CD [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
(non-indexed) views are queries stored in db and expanded when used in other queries. Indexes materializes view creating table like structure. As mentioned above, read more in Books-on-line.