OraFAQ Forum: Performance Tuning » Query Taking very long time

Home » RDBMS Server » Performance Tuning » Query Taking very long time (Oracle 10g)

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

Query Taking very long time [message #342070]

Thu, 21 August 2008 04:55

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Hi,

I am using custom function in my query. in that custom function i am using the percentile function. It is taking very long time to execute. How to reduce the timings??

Any hint should i use??

Report message to a moderator

Re: Query Taking very long time [message #342074 is a reply to message #342070]

Thu, 21 August 2008 04:59

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

Senior Member
Account Moderator

Quote:

Any hint should i use??

* Don't use it
* Improve the way you use it
* Build your own function
* ...

Regards
Michel

Report message to a moderator

Re: Query Taking very long time [message #342076 is a reply to message #342070]

Thu, 21 August 2008 05:02

spmano1983
Messages: 269
Registered: September 2007

Senior Member

Already function created. when i use the custom function in the query, it is taking long time to execute otherwise it is working fine. How to make this fast??

Report message to a moderator