how fast the joins will work in subquery|sql server?

Question

Select col1 from A where A.col1 in(Select distinct col1 from B where col1 is not null)
Select A.col1 from A inner join (select distinct col1 from B where col1 is not null) B on A.col1 = B.col1

Which is the more efficient one?and why?

Answer:

Joins are working fast when compared with the Subquery in any SQL Query. In Subquery main query is in waiting state until the completion of inner query but in Joins it is different.

For more Details Visit: https://tekslate.com/msbi-training/

Bharathi Raja · Answer

SELECT * FROM crv.workorder_details wd inner join crv.workorder wr on wr.workorder_id = wd.workorder_id; Result : 13.3 Seconds select * from crv.workorder_details where workorder_id in ( select workorder_id from crv.workorder) Result : 1.65 Seconds

Manish Kumar · Answer

Check below link https://stackoverflow.com/questions/14052596/subquery-v-s-inner-join-in-sql-server In simple word join will look for linear matching so it is fast while subquery go for matching all records. Further Its depends on execution plan. Some times plan for join and subquery will be same.