Uli,

<< I want to update the values of a joined table which takes about 13
seconds with this statement: >>

Can you send me your catalog and relevant tables ?  I'll check it out and
see what can be done.  EDB may be doing an unnecessary row scan.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Tim,
> Can you send me your catalog and relevant tables ?  I'll check it out
> and see what can be done.  EDB may be doing an unnecessary row scan.

Sure - coming soon....

Uli

Roy Lambert wrote:

> Had a few minutes to spare
>
> SCRIPT
> BEGIN
> DECLARE IDList VARCHAR DEFAULT '';
> DECLARE ResultCursor CURSOR WITH RETURN FOR ResultStmt;
> EXECUTE IMMEDIATE 'SELECT LIST(CAST(_ID AS VARCHAR),'','') INTO ?
> FROM Companies WHERE _Name LIKE ''W%''' USING IDList; PREPARE
> ResultStmt FROM 'SELECT * FROM Companies WHERE _ID IN ('+IDList+')';
> OPEN ResultCursor; END

Roy,

Thank you very much for that code snippet.

I considered that to be a fundemental ElevateDB building block. I'm
most likely going to blog about this fairly soon and I'd like to give
you credit for the concept and a link back to your website is that okay
with you?

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

Uli,

<< Sure - coming soon.... >>

Thanks.  Reporting back: no improvement (actually slightly worse) on my
suggestion:

Update Leistungentest L set year = year + 1
where AnforderungenID = (select AnforderungenID from Anforderungen A
                        where A.AnforderungenID=L.AnforderungenID AND Datum
>= date '2013-8-20')

I'll have to do some profiling to see where the time is being spent.
However, it could just be an issue with the fact that the update table
simply has to be scanned in its entirety, and there's not much I can do
about that.

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<<
I'll have to do some profiling to see where the time is being spent.
However, it could just be an issue with the fact that the update table
simply has to be scanned in its entirety, and there's not much I can do
about that.
>>

Tim,

Thanks for the feedback.

Michael Riley
GySgt USMC (Ret)
www.zilchworks.com