SQL Plus - Subquery vs Join

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 58 of 132

Subquery vs Join

Total Answers and Comments: 3

Last Update: July 11, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 24, 2005 20:23:53

pallavi

RE: Subquery vs Join

The main difference betwen subquery and join is
subquery is faster when we have to retrieve data from large number of tables.Because it becomes tedious to join more tables.
join is faster to retrieve data from database when we have less number of tables

Is this answer useful? Yes | No

January 02, 2006 08:16:13

ravi wadalkar

RE: Subquery vs Join

subquery retrive the data depending on certain condition or manupulation in inner query.

where as joins will join the enitire data depending on the conditions given it cannot manupulate the data or we cannot be selective while using joins

Is this answer useful? Yes | No

July 11, 2007 02:35:10

Rajeev Ranjan

RE: Subquery vs Join

We can be selective in joins query. e.g.

select e.name d.city
from employee e
inner join detail d
on e.employee_id d.employee_id and d.city in('aaa' bbbb' 'cccc')

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank