help on a cursor/fetch

From: Phil Chapman <pchapman_at_bellsouth.net>
Date: Sun, 29 Aug 1999 13:00:39 -0400
Message-ID: <MOdy3.14365$Zi2.84903@news4.mco>

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 Sun Aug 29 1999 - 12:00:39 CDT