Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 9273 Views
- ASD Lab, I also Faced
- E-Mail Answers
Answer Posted / divya kalra
Subqueries can often be re-written to use a standard outer
join, resulting in faster performance. As we may know, an
outer join uses the plus sign (+) operator to tell the
database to return all non-matching rows with NULL values.
Hence we combine the outer join with a NULL test in the
WHERE clause to reproduce the result set without using a
sub-query.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the fillfactor concept in indexes?
Do you know what is similarity and difference between truncate and delete in sql?
How does normalization work?
What is etl - extraction, transformation, and loading?
Tell about MOM Tool(Microsoft Operator Manager)?
What are the disadvantages of merge replication?
How to verify the port number of the sql server?
Does any body please help me what question's have asked for SSRS in the interview?
What is page in sql server?
What happens if the update subquery returns no rows in ms sql server?
How to recompile stored procedure at run time?
What is checkpoint process in the sql server?
List all the types of user-defined functions?
What are different type of Collation Sensitivity?
What is raiseerror? What is raiseerror?
