does VIEWS consume storage area in MS SQL server?

Question

does MS SQL VIews consume storage area in the disk/database.

I know MS ACCESS Views consumes space because when I create views the file size increases.

Is this the same for MS SQL server?

Answer 1

It depends. The SQL has a reserved space for views. But in case you run a view that brings lots of information, or in case that you run multiple views the size will increase. Both in Access and SQL you need to "compact" the databases to remove any unwanted space. Generally speaking SQL engine cleans the temp spaces, but from what I know it does not shrink the actual file size.



Also look into the source link for using the SQL maintenance plan. The maintenance plan can clean temp spaces and re-organize indexes.

Answer 2

Cluster Indexed Views consumes almost same amount of the space as original retrieved data

Answer 3

Yes it does because it is already an object entity that takes up storage.