Re: what is the fastest way to update a big table (50000rows*20columns)

correction to the code:

   UPDATE cs c
   SET source=(SELECT j.source

                       FROM JOIN j
                      WHERE j.totid = c.totid)
  WHERE totid IN (SELECT totid FROM join
                               WHERE source IS NOT NULL);     <<<<< added

Roel Received on Thu Nov 01 2001 - 04:35:15 CET