Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Prague
    Posts
    77

    Unanswered: large table update

    hello, i have a following problem: I have got 130 million row TABLEA
    and I need to run this update:
    UPDATE TABLEA
    SET COLUMNA=(SELECT COLUMNB FROM TABLEB WHERE condition)

    I suppose that for every row from TABLEA (80 million times) select statement must be executed, which is terribly slow. Isn't there a better way to write this update? Thank you

  2. #2
    Join Date
    Jul 2002
    Posts
    229
    Could you provide the WHERE clause in detail, pls?

  3. #3
    Join Date
    Aug 2002
    Location
    Prague
    Posts
    77
    Originally posted by Coolberg
    Could you provide the WHERE clause in detail, pls?

    WHERE column from TABLEA=column FROM TABLEB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •