help on a cursor/fetch

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 - 00:00:00 CEST