Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 9288 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 join and name different type of joins?
What is merge?
What is buffer cash and log cache in sql server?
What is normalization 1nf 2nf 3nf?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is snapshot replication?
What is self contained scalar sub query?
What are the operating modes in which database mirroring runs?
What is the difference between count () and rowcount ()?
explain different types of cursors? : Sql server database administration
How to create indexed view?
what is the difference between a primary key and a unique key? : Sql server database administration
Why are sql functions used?
Explain use of expression builder.
What happens on checkpoint?
