Views RRS feed

  • Question

  • Outside of the network consumed by return of the result, is there a performance difference in running a multi-table join view on the sql server as opposed to remote client?

    Thanks in advance

    Tuesday, November 7, 2017 12:14 AM

All replies

  • No difference because there's no such thing, everything always runs on the server.

    Unless you're talking linked servers, or something like that.  Then, in general, yes there could be a huge difference, can't really optimize across servers.


    Tuesday, November 7, 2017 12:19 AM
  • Whatever network latency introduces to response time from client side is about the only thing I can think of.

    If their is a large data payload, I have seen cases where there is significant ASYNC_NETWORK_IO wait type that contributes to degraded response time as well.

    This happens when SQL Server is pushing requested data back to the app faster than the client can consume it, resulting in backlog.

    Hope that helps, 

    Phil Streiff, MCDBA, MCITP, MCSA

    Tuesday, November 7, 2017 1:41 AM
  • Even when result set is small?
    Tuesday, November 7, 2017 3:02 PM
  • A SQL Server "view" is simply a collection of predefined TSQL code.  There is no difference between running SELECT * FROM VIEW and running the code from the view directly.  Views are not a performance tuning tool.

    SQL Server does not precompile views, like Oracle does.

    Tuesday, November 7, 2017 3:07 PM