"Sabin Coanda" wrote:
> I have just a function returning a cursor based on a single coplex
> query. When I check the execution plan of that query it takes
> about 3 seconds. Just when it is used inside the function it
> freezes.
>
> This is the problem, and this is the reason I cannot imagine w
I have just a function returning a cursor based on a single coplex query.
When I check the execution plan of that query it takes about 3 seconds. Just
when it is used inside the function it freezes.
This is the problem, and this is the reason I cannot imagine what is happen.
Also I tried to rec
On Fri Apr 9 2010 8:18 AM, Sabin Coanda wrote:
I have just a function returning a cursor based on a single coplex query.
When I check the execution plan of that query it takes about 3 seconds. Just
when it is used inside the function it freezes.
This is the problem, and this is the reason I cann
On Wed Apr 7 2010 7:47 AM, Sabin Coanda wrote:
Hi there,
I have a function which returns setof record based on a specific query.
I try to check the execution plan of that query, so I write EXPLAIN ANALYZE
before my select, I call the function and I see the result which shows an
actual time about
Maybe other details about the source of the problem help.
The problem occured when I tried to optimize the specified function. It was
running in about 3 seconds, and I needed to be faster. I make some changes
and I run the well known "CREATE OR REPLACE FUNCTION ..." After that, my
function exec
Hi there,
I have a function which returns setof record based on a specific query.
I try to check the execution plan of that query, so I write EXPLAIN ANALYZE
before my select, I call the function and I see the result which shows an
actual time about 5 seconds. But when I call my function after I
