Can we rewrite subqueries into simple select statements or
with joins? Example?
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
How can we check the sql server version?
Do you know sql server 2008 backup compression?
What is meant by Active-Passive and Active-Active clustering setup?
What do you mean by recursive stored procedure?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What do you mean by authentication modes in sql server?
How to count groups returned with the group by clause in ms sql server?
Explain mixed authentication mode of sql server?
Define inner join in sql server joins?
What do you mean by an execution plan? Why is it used?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What are the options which must be set to allow the usage of optimistic models?
What are the types of normalization?
What is the difference between functions and scalar functions?
Explain full-text query in sql server?