Performance issue in a function

From: Sujatha <sujakris_at_gmail.com>
Date: 12 Jul 2006 09:24:34 -0700
Message-ID: <1152721474.120607.95200@m73g2000cwd.googlegroups.com>

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