Home Forums SQLServerCentral.com SQLServerCentral.com Test Forum How view will help in performance and how can i identify tempdb is full RE: How view will help in performance and how can i identify tempdb is full

  • December 30, 2011 at 2:19 am

    #1426799

    vaithi.saran846 (12/29/2011)

    Hi,

    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?

    regards,

    vaithilingam.k

    If you're having problems with the performance of a complex query, why not post the query and the actual execution plan? Chances are, folks here will make suggestions to improve performance - and you are very likely to learn something useful too.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]