Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance issue in a function
Sujatha wrote:
> Hi,
>
> I have a main view from where all the columns are displayed at front
> end.
> This view has 6 subqueries in it, of which in one of the view, if i
> comment a function to get an amount based on a input value, it brings
> records in 10-15 secs. If i dont comment, then it takes about 2 mins.
>
> The same function i have used in other views but only in this view it
> is taking a long time. This view retrieves more than 2500 records but
> the others has very few records(say about 10-15 records at the max.)
>
> Can anybody give me any suggestions to solve the problem?
>
> Note:
> I have used cost based optimizer. All my tables are analyzed and have
> statistics collected.
>
> Thanks
> Regards
> Sujatha.k
No SQL
No Explain Plan
No version
No Advice.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Jul 12 2006 - 11:38:57 CDT