SQL Server Performance Forum – Threads Archive
are Views stored in data base physically or logic
are 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.
Madhu
.. updated BOL is better than installing from CD [<img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
(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.
]]>