SQL Server Performance

views from Views

Discussion in 'General Developer Questions' started by mahasund, May 30, 2007.

  1. mahasund New Member

    I have created views from complex algorithm.

    Is is advisble to join two views to get the data. Will there be any performance issues?
    or for that matter any issues.

    Any/All help is greatly appreciated,

    Thanks,
  2. deepakontheweb New Member

    Performance will totally depends on columns you are selecting from both views, and execution plans of both views in actual.



    Deepak Kumar
    SQL Server MVP, MCDBA
    deepak.kumar@sqlknowledge.com

    Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
  3. satya Moderator

    If you are using SQL Enterprise edition then indexed views are better for such a performance, refer to the updated books online for more information.

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/indexvw.mspx
    http://www.sql-server-performance.com/views.asp - perf. tuning tips.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page