• Thanks Erland excellent response thank you , so my understanding is ... the view contains the sql and because the view can be accessed so as to cause a very large operation to occur on it it "potentially" could have an impact if the resulting query on the view is poorly used .The actual view itself does not have any requirements for resources until called

    E.G. select top 1 no problem at all , select * from is going to take a while and have heavy usage of tempdb .