Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011

    Unanswered: updating new column in sybase

    Hi All,

    I am facing a problem to update the new column in sybase

    My sybase version is 11.0.3
    I have to add a new column in a table having around 90 million records

    Now i have to update this column with a default value of 3
    Now i know there is no way in current sybase version to set a default value with a new column, i have to update the column with the value of 3, but just becuase of large size of table it is taking more than 2 days to update the column.

    i am first capturing the an indexed column of the table in the cursor and
    then updating the new column in the table using this indexed column
    Please can i have any bright ideas how to update the column as quickly.

    Thanks in Advance!!

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    Don't use a cursor.
    update in batches e.g. where key between 1 and 10000000 depending on your log size

Posting Permissions

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