469,631 Members | 1,126 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Which one is bigger (takes more disk space) - a view (sql query) or a table?

Good afternoon,

I have the following question (it might seem silly, but it is important to have it straight) - which one takes more disk space a saved view in a SQL SERVER database (sql query that will woutput columns and rows) or a table itself stored in a SQL SERVER database that contains the same rows and columns as the view? The thing is that the data in the table and the view is stored actually in other tables where I use a many-to-many relation.

I will also very much appreciate an answer which states the exact difference in disk space :)

Thank you in advance,
Jul 12 '07 #1
1 1201
8,127 Expert 4TB
as per the defination a view is a virtual table . Ok

A view does not acquire any space in a disc.
Jul 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by John | last post: by
2 posts views Thread by WertmanTheMad | last post: by
3 posts views Thread by brendan_gallagher_2001 | last post: by
5 posts views Thread by rAinDeEr | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.