Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Performance issue in a function
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
Received on Wed Jul 12 2006 - 11:24:34 CDT
![]() |
![]() |