Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
how fast the joins will work in subquery|sql server?
Online Sahu
Nov 11 2017 2:31 AM
222
Reply
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/
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How to use 'N' number of for loop concept in SQL Server.
select dynamic database