Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

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

Home
Forums

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

Online Sahu

8yAsked Nov 11, 2017, 2:31 AM937

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/

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Bharathi Raja8y ago
1. SELECT *
2. FROM crv.workorder_details wd
3. inner join crv.workorder wr on wr.workorder_id = wd.workorder_id;
5. Result : 13.3 Seconds
7. select *
8. from crv.workorder_details
9. where workorder_id in (select workorder_id from crv.workorder)
12. Result : 1.65 Seconds

Manish Kumar8y ago

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.