Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 8269 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 create statement?
How to modify existing triggers using "alter trigger"?
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?
Do you know what is replace and stuff function in sql server?
Tell me in brief how sql server enhances scalability of the database system?
What is sql view?
What is forward - only cursors / read only cursor?
What do you mean by a dependent functionality in a build?
How to set database to be read_only in ms sql server?
What are different types of collation sensitivity?
What is a sql join?
When cursors are useful?
What are diverse clauses that form a part of sql?
How to recreate an existing index in ms sql server?
What stored by the model? : sql server database administration
