On 10/29/07, Campbell, Lance <lance@uiuc.edu> wrote:
> Thanks for all of your help. The problem was that the result_entry table
> had some constraints that pointed to a third table. When I removed
> those constraints the performance was amazing. The update took less
> than seven minutes to execute. I did not even consider the fact that
> constraints to another table would impact the performance.
Usually you can put an index on the refrerenced key in the foreign
table to speed things up.
