How much space does a view take up in Microsoft SQL Server

sql-server sql-view
Great Turtle picture Great Turtle · Dec 3, 2010 · Viewed 10.6k times · Source

I have a very large table in SQL Server 2008. It has lots of fields which are only useful to a certain segment of users, some of the fields some users shouldn't be able to see.

The table is huge so I wanted to create some simple views for each user class where I could give them access to the view and they could only see the columns they need.

Does a view take up space in the database, or would it be saved as a simple select statement?

Answer

Randy Minder picture Randy Minder · Dec 3, 2010

Unless the view is indexed, it takes up almost no space, except for the definition of the view. The view itself is not like a table in that it physically stores rows in the database (unless it is an indexed view). It is only materialized (retrieves data) when it is called

Related questions

Create view with primary key?

I create a view with following codes SELECT CONVERT(NVARCHAR, YEAR(okuma_tarihi)) + 'T1' AS sno, YEAR(okuma_tarihi) AS Yillar, SUM(toplam_kullanim_T1) AS TotalUsageValue, 'T1' AS UsageType FROM TblSayacOkumalari GROUP BY CONVERT(NVARCHAR, YEAR(okuma_…

Read More
Create View - Declare a variable

I am creating a view that is using that STUFF function. I want to put the result of STUFF in a variable for my view. The problem I am having is declaring my variable. It gives me the message "Incorrect …

Read More
Why do SQL Server Views needs to be refreshed every once in a while

Why do I have to write 'refresh view' scripts, and execute them every time I add or edit some fields to a view? SQL Server understands that it needs to refresh the view when editing it in the fancy view-edit …

Read More