Home Forums SQL Server 2014 Administration - SQL Server 2014 View VS Select from Table RE: View VS Select from Table

  • February 7, 2018 at 6:45 am

    #1978854

    subramaniam.chandrasekar - Wednesday, February 7, 2018 12:53 AM

    VastSQL - Wednesday, February 7, 2018 12:48 AM

    Experts,

    We have a procedure which select from a lot of tables. Will there be any performance improvement if we create a view for that select query instead of fetching directly from Table?

    Obviously yes, We'd implemented the same when we wanted to share our data to shared services team.

    I'd be interesting in know how - maybe it's not that obvious.
    It was my understanding that the optimizer doesn't even know it's a view - all that gets to the optimizer is the query that is the definition of the view. So it wouldn't be the optimizer slowing things down. What exactly makes it slower when either the query or the view and it's executing the same thing?

    Sue