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 1:24 am

    #1426792

    View is mainly used for encapsulation, that is, hiding the complexity. In terms of performance, It will not help you a lot. For that, you need to go with " indexed views "