OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » function tunning (9i)

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

function tunning [message #384762]

Thu, 05 February 2009 01:55

mohannksr
Messages: 28
Registered: January 2009

Junior Member

hi,

i have attached a function.
does anyone tell me how to tune it...?

Attachment: get_actual_vpf_date.txt
(Size: 0.89KB, Downloaded 1216 times)

Report message to a moderator

Re: function tunning [message #384764 is a reply to message #384762]

Thu, 05 February 2009 02:03

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can do it in a single SQL statement using ROW_NUMBER function.

By the way, if you can have rows with same from_date your code is not deterministic.

Regards
Michel

[Updated on: Thu, 05 February 2009 02:03]

Report message to a moderator

Re: function tunning [message #384765 is a reply to message #384764]

Thu, 05 February 2009 02:08

mohannksr
Messages: 28
Registered: January 2009

Junior Member

Thanks a lot michel.

i have replaced the for loop
with the single query.....

Report message to a moderator

Previous Topic:	Tuning on Window Server
Next Topic:	Top 5 Events

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:23:47 CST 2024