Re: help on a cursor/fetch

    Try building a view from the join and making the fetch on this new view.

    Agur,

                                                                Agustín Menéndez

Phil Chapman escribió:

> 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 Wed Sep 01 1999 - 02:16:01 CDT