Re: help on a cursor/fetch

Run a explain plan. Try forcing a hash join if it isn't already doing one ( u can try using teh 'ordered' hint) You should see a dramatic improvement. The result set, BTW, is large but not large enough to cause a 3 minute time interval. Again, this also depends on the size of the tables being joined. Try placing the smaller table first in your from clause and see if Oracle chooses teh HASH path. Best of luck.

Venkat

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

--

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
        _   __         __        __
       | | / /__ ___  / /_____ _/ /_   Email :
       | |/ / -_) _ \/  '_/ _ `/ __/    venkat1_at_one.net
       |___/\__/_//_/_/\_\\_,_/\__/     venkat_rajagopal_at_yahoo.com

                  < http://w3.one.net/~venkat1 >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++