tag:blogger.com,1999:blog-495177919198719500.post7648623691592714596..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: SQL Server - Which is faster INNER JOIN or LEFT JOIN?Suprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-495177919198719500.post-11386439142487457602013-02-13T22:28:53.481-08:002013-02-13T22:28:53.481-08:00Since this article is misleading, could you please...Since this article is misleading, could you please edit or removed it?Pravinnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-4012949435896384292013-01-22T04:22:21.689-08:002013-01-22T04:22:21.689-08:00Yes, I did.
If I run the execution plan of both q...Yes, I did.<br /><br />If I run the execution plan of both queries the result is exactly the same. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-86213601206515216482013-01-16T00:36:17.627-08:002013-01-16T00:36:17.627-08:00Piwopx, Ok. Did you run the same for LEFT JOIN too...Piwopx, Ok. Did you run the same for LEFT JOIN too?Madhivananhttp://beyondrelational.com/blogs/madhivanannoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-30569581320540792972013-01-11T01:34:57.597-08:002013-01-11T01:34:57.597-08:00Hi.
Try to invert the order of execution. In my t...Hi.<br /><br />Try to invert the order of execution. In my tests the first query always is faster then the second one.<br /><br />In other test I write 4 times the same query. These are the results:<br /> Tiempos de ejecución de SQL Server:<br /> Tiempo de CPU = 0 ms, tiempo transcurrido = 0 ms.<br /><br />(659 filas afectadas)<br /><br /> Tiempos de ejecución de SQL Server:<br /> Tiempo de CPU = 0 ms, tiempo transcurrido = 1 ms.<br /><br />(659 filas afectadas)<br /><br /> Tiempos de ejecución de SQL Server:<br /> Tiempo de CPU = 0 ms, tiempo transcurrido = 114 ms.<br /><br />(659 filas afectadas)<br /><br /> Tiempos de ejecución de SQL Server:<br /> Tiempo de CPU = 0 ms, tiempo transcurrido = 137 ms.<br /><br />Maybe you need a better way to meassure execution time.<br />Piwopxnoreply@blogger.com