OraFAQ Forum: SQL & PL/SQL » which one is more faster

Home » SQL & PL/SQL » SQL & PL/SQL » which one is more faster

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

which one is more faster [message #408565]

Tue, 16 June 2009 20:49

kpvssagar
Messages: 2
Registered: June 2009
Location: HYDERABAD

Junior Member

1) among functions and procedures

2) among sub-queries and joins

Report message to a moderator

Re: which one is more faster [message #408567 is a reply to message #408565]

Tue, 16 June 2009 20:53

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: which one is more faster [message #408569 is a reply to message #408567]

Tue, 16 June 2009 21:02

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

Report message to a moderator

Previous Topic:	ORA-23319 error
Next Topic:	Ref cursor and parsing the string question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 18 05:42:51 CDT 2025