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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • siskokid
    New Member
    • Jul 2007
    • 1

    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,
    siskokid
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    as per the defination a view is a virtual table . Ok

    A view does not acquire any space in a disc.

    Comment

    Working...