Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 9393 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 difference between for trigger and after trigger?
What are the types of table?
What is report snapshot?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Why normalization is used?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
whats new about truncate in sql server 2008?
What is the purpose of self join?
What is replication with database mirroring? : sql server database administration
Explain what is row_number function?
How to disconnect from a sql server using mssql_close()?
How can you insert null values in a column while inserting the data?
What does Master database contains?
How to bind a view to the schema of the underlying tables?
Explain transaction server auto commit?
