Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11361 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajeevrohilla
In normal situation join are best since there is no
subquery for each record for the other table. but in some
situations Subquery are best. for example- when the
subquery results one or fewer (3 or 4 records) that it will
work faster since it also saves the joining time(if there
are more than 1 joining fields then joining takes lots of
time). Subquries also perform better when tables have less
amount of data.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
What is the parse query button used for?
What is the difference between insensitive and scroll cursor?
What is use of @@ spid in sql server?
How many servers can we create in a single subscription?
What is a self join in sql server?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is the difference between left and right outer join?
Can you tell me about the concept of ER diagrams?
What is amo? : sql server analysis services, ssas
What happens if we shrink log file in sql server?
Explain mixed authentication mode of sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Is null in sql server?
Explain system functions or built-in functions? What are different types of system functions?
What is the use of partition by in sql server?
