Home » RDBMS Server » Performance Tuning » Query Taking very long time (Oracle 10g)
Query Taking very long time [message #342070] Thu, 21 August 2008 04:55 Go to next message
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??

Re: Query Taking very long time [message #342074 is a reply to message #342070] Thu, 21 August 2008 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Query Taking very long time [message #342076 is a reply to message #342070] Thu, 21 August 2008 05:02 Go to previous messageGo to next message
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??
Re: Query Taking very long time [message #342085 is a reply to message #342076] Thu, 21 August 2008 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Buy more powerful CPU.

Regards
Michel
Re: Query Taking very long time [message #342091 is a reply to message #342070] Thu, 21 August 2008 05:31 Go to previous message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi Michel,

Thanks for your reply.

Previous Topic: how to calculate IO for specific SQL Query...
Next Topic: Performance Tunning issue 9i
Goto Forum:
  


Current Time: Fri Dec 02 14:14:02 CST 2016

Total time taken to generate the page: 0.13378 seconds