Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11254 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 are different types of views?
Explain about unique identifier data type in sql server?
How to include text values in sql statements?
Do you know what are the differences between lost updates and uncommitted dependencies?
Why people hate cursor?
Why use “pivot” in sql server?
What is proper subset of candidate key?
How to create percentile function?
how to create “alternate row colour”?
How to make conditional sum in ssrs?
What the different topologies in which replication can be configured?
Do you know what is rank function?
What are the disadvantages of using the stored procedures?
What is outer join in sql server joins?
What do you mean by a dependent functionality in a build?
