SQLServerCentral / Data Warehousing / Performance Point / Table select statement performance / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 07:35:47 GMT20RE: Table select statement performancehttp://www.sqlservercentral.com/Forums/Topic1236386-2796-1.aspx...and I would recommend specifying the join type for readability if using the improved ANSI joins:INNER JOIN (default)RIGHT OUTER JOINLEFT OUTER JOIN etc etcMon, 16 Jan 2012 01:52:16 GMTRobert Murphy UK1RE: Table select statement performancehttp://www.sqlservercentral.com/Forums/Topic1236386-2796-1.aspxThey will perform the same (same execution plan), the only difference is one uses the ANSI syntax and the other the old style SQL Server / Sybase syntax.Mon, 16 Jan 2012 01:48:49 GMTRobert Murphy UK1Table select statement performancehttp://www.sqlservercentral.com/Forums/Topic1236386-2796-1.aspxDear Friends,I am having two tables TB_PERSON_P and TB_PERSON_Rboth having a common column R_IDnow we can write two query:select R_ID from TB_PERSON_P P,TB_PERSON_R R where P.R_ID=R.R_IDandSelect R_ID from TB_PERSON_P P join TB_PERSON_R on P.R_ID=R.R_IDwhich would be faster among these two statement?Thanks!!Sun, 15 Jan 2012 22:48:37 GMTshubham.saxena67