OraFAQ Forum: SQL & PL/SQL » Efficient way of retrieving

Home » SQL & PL/SQL » SQL & PL/SQL » Efficient way of retrieving - Joining Vs In line view (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Efficient way of retrieving - Joining Vs In line view [message #571975]

Wed, 05 December 2012 01:17

saipradyumn
Messages: 131
Registered: October 2011
Location: Hyderabad

Senior Member

Hi All ,

Could you please let us know which one is efficient way retrieving the information between Join Vs inline view

1: By using Joining

Select  e,* , d.dname  from scott.emp e , scott.dept  d where  e.deptno=d.deptno  ;

2: By using In line view

select e.*, (select d.dname from scott.dept d where d.deptno = e.deptno) dname   from scott.emp e

This is just simple example. I have same kind situation in my actual requirement also.
Do we have any other factors to decide?

Thanks
SaiPradyumn

Report message to a moderator

Re: Efficient way of retrieving - Joining Vs In line view [message #571979 is a reply to message #571975]

Wed, 05 December 2012 01:24

Michel Cadot
Messages: 54698
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1. is the most efficient.

You didn't feedback to and/or thank in your previous topics; this is a rude and scornful behaviour that deserves to be no more helped.
Please review your previous topics and comply to the least rules of politeness.

Regards
Michel

Report message to a moderator

Re: Efficient way of retrieving - Joining Vs In line view [message #571981 is a reply to message #571979]

Wed, 05 December 2012 01:56

saipradyumn
Messages: 131
Registered: October 2011
Location: Hyderabad

Senior Member

Hi Michel ,

I am really extremely sorry for that one.It's very difficult to solve all of my problems with out your help.

Thanks
SaiPradyumn

Report message to a moderator

Previous Topic:	Sequence increments when it is not being called.
Next Topic:	Associative Array help - no data found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 05:54:41 CDT 2013

Total time taken to generate the page: 0.12247 seconds