Re: help on a cursor/fetch

From: Jeff Smith <spamnadajsmith_at_provide.net>
Date: Mon, 30 Aug 1999 09:47:05 -0400
Message-ID: <37CA8B59.E52E0479@provide.net>

That is a big result set. To test your problem try reducing it... maybe add an 'AND ROWNUM < 1001'. ( keep your result set to 1000 rows )

This will reduce the size of your rowset and at least let you know if that is where your problem lies...

Jeff Smith

Phil Chapman wrote:
>
> Hi,
> I have a production problem which I cannot quite figure out. I have a
> join between two tables which produced a result set of ~300,000 rows, within
> the program every fetch takes around 3 minutes. I have tried analyzing the
> tables with compute statistics on and recompiling the program using the sql
> but to no avail. I'm not even sure how I can progress in finding out the
> cause.
>
> Could it be potentially caused by a lack of space building the result set?
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Phil
Received on Mon Aug 30 1999 - 08:47:05 CDT