what is the main advantage of view.? How view will help in performance. consider i have the some complex select query and i am running that in sql server and it is taking lot of time. In this case if i use view, how it will affect? whether the time taken by select query will reduce?