Sunday, 25 August 2013

SQL : Which of the below query has better performance ( "IN" vs "=" )?

SQL : Which of the below query has better performance ( "IN" vs "=" )?

Query 1:
Select column_name from table where coloumn_first IN (select column_second
from table2);
Query 2:
select column_name from table, table2 where column_first =
table2.column_second;

No comments:

Post a Comment