Re: Suggestions on an update query

["Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>]

On 10/29/07, Campbell, Lance <lance(at)uiuc(dot)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.