Home » RDBMS Server » Performance Tuning » function tunning (9i)
function tunning [message #384762] Thu, 05 February 2009 01:55 Go to next message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
hi,

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

Re: function tunning [message #384764 is a reply to message #384762] Thu, 05 February 2009 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
Thanks a lot michel.

i have replaced the for loop
with the single query.....
Previous Topic: Tuning on Window Server
Next Topic: Top 5 Events
Goto Forum:
  


Current Time: Sat Dec 03 08:17:46 CST 2016

Total time taken to generate the page: 0.05068 seconds