Home » SQL & PL/SQL » SQL & PL/SQL » which one is more faster
which one is more faster [message #408565] Tue, 16 June 2009 20:49 Go to next message
kpvssagar
Messages: 2
Registered: June 2009
Location: HYDERABAD
Junior Member
1) among functions and procedures

2) among sub-queries and joins
Re: which one is more faster [message #408567 is a reply to message #408565] Tue, 16 June 2009 20:53 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

>1) among functions and procedures
It depends.
Run your own benchmark test & post results

>2) among sub-queries and joins
It depends.
Run your own benchmark test & post results
Re: which one is more faster [message #408569 is a reply to message #408567] Tue, 16 June 2009 21:02 Go to previous message
kpvssagar
Messages: 2
Registered: June 2009
Location: HYDERABAD
Junior Member
k sure am new to this site
will test and try to post the results
Previous Topic: ORA-23319 error
Next Topic: Ref cursor and parsing the string question
Goto Forum:
  


Current Time: Sat Dec 03 12:12:37 CST 2016

Total time taken to generate the page: 0.05920 seconds