mail2shekar06
Grasshopper
Points: 21
More actions
April 16, 2009 at 4:53 pm
#203601
Do VIEWS created on tables occupy space in disk
Jeffrey Williams
SSC Guru
Points: 90350
April 16, 2009 at 5:01 pm
#979333
No - views are not materialized. The view definition is expanded into the calling query and used to generate the final query to be executed.
The view definition itself will take up a few bytes in the system tables - but hardly noticable at all.
Jeffrey Williams“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers fasterManaging Transaction Logs
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply