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=’

‘ />]. <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</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.

]]>