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,
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.
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.
