Re: Too Many Cursors?
From: Yuri Ivanov <trak_at_trak.spb.ru>
Date: Tue, 04 Oct 2005 20:32:56 +0400
Message-ID: <dhuaqo$8si$1_at_news.rol.ru>
>
>
> Thanks, Yuri. I did consider that. The trouble with that, of course,
> is that it assumes that the function I wrote opens only a normal
> number of cursors. It looks to me that there's a problem with that
> assumption.
> --
> Helge Moulding
> hmoulding at gmail dot com Just another guy
> http://hmoulding.cjb.net/ with a weird name
>
Now I catch what you want.
But IMHO, better to optimize your first query, than use any user-defined function in the query.
Date: Tue, 04 Oct 2005 20:32:56 +0400
Message-ID: <dhuaqo$8si$1_at_news.rol.ru>
Helge Moulding пишет:
> Yuri Ivanov wrote:
>
>>May be you can increase OPEN_CURSORS parameter in your instance?
>
>
> Thanks, Yuri. I did consider that. The trouble with that, of course,
> is that it assumes that the function I wrote opens only a normal
> number of cursors. It looks to me that there's a problem with that
> assumption.
> --
> Helge Moulding
> hmoulding at gmail dot com Just another guy
> http://hmoulding.cjb.net/ with a weird name
>
Now I catch what you want.
But IMHO, better to optimize your first query, than use any user-defined function in the query.
Please, set timing ON
and show me a time for your both queryes and for one my :)
select a.val1
,b.val2 ,b.val3 from a_table a, b_table b where a.val2 = 'a' and a.key = b.a_key and NOT EXISTS (select * from b_table b2 where b.a_key = b2.a_key and b2.val4 > b.val4 );
Please :)
And talk me version of your RDBMS and information about indexes :)
Received on Tue Oct 04 2005 - 18:32:56 CEST