Post reply

Data Retrieval Performance

  • June 24, 2008 at 5:56 am

    #189598

    If we used views and queried them will that be much faster than

    having a query over many tables using joins??

  • June 24, 2008 at 6:08 am

    #833259

    Most likely it will be exactly the same.

    A view is just a saved select statement. It doesn't store data at all. When you query a view you are just running the select statement that defines the view.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 26, 2008 at 10:22 am

    #834826

    The view could be faster if it is a materialized / indexed view, but in my experience there are so many constraints on when you can use a materialized view and what can be in them that I have rarely used them.

    If a view references another view it could be slower based on some items I have read, though I have not ever tried it so I have not proofed that out yet.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply