December 2, 2011 at 6:53 am
If I create a view, is it slowing down operations at any time other than when I actually use the view to do a select? I wouldn't think so, but I don't want to inadvertantly slow down the system for an occaissional report. Thanks.
*******************
What I lack in youth, I make up for in immaturity!
December 2, 2011 at 6:58 am
Unless you're talking about indexed views, then no, they have no measurable effect on resource usage when not being used
December 2, 2011 at 8:56 am
The only way a view would take up any resources is if it were indexed. In the case of an Indexed View you need enough disk space for the index.
December 2, 2011 at 9:00 am
Okay, thanks.
*******************
What I lack in youth, I make up for in immaturity!
December 2, 2011 at 9:08 am
Bill Hansen (12/2/2011)
The only way a view would take up any resources is if it were indexed. In the case of an Indexed View you need enough disk space for the index.
The maintenance of the index is also wrapped into the execution plans for DML statements for the constituent tables. However, sounds like we're just talking about regular views.
December 2, 2011 at 9:10 am
Yes, unindexed views. I would love to index some of my views, but the database I'm working on was created without schemabinding. Thanks again.
*******************
What I lack in youth, I make up for in immaturity!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply