Re: Poorly performing UPDATE.
I resolved the performance problem by switching the corrolated subquery to use an alterate main table compound key consisting only of numeric values.
What this tells me is that the engine string comparison logic is a really poor performer. I'll have to rethink my table structures to eliminate string comparisons where ever possible.
Subject
Views
Written By
Posted
1845
February 09, 2011 02:12PM
785
February 10, 2011 09:51PM
Re: Poorly performing UPDATE.
970
February 12, 2011 07:09AM
731
February 12, 2011 04:06PM
748
February 14, 2011 08:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.