Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2014

    Unhappy Unanswered: Updating table in informix

    I have a table which has around 40millions of records. There are some program that going to update records in that table which don't have indexes.
    This program updates the table with full record update not to specific fields.

    column1 column2 column3 column4 column5
    1 1 1 1 1
    2 2 2 2 2
    3 3 3 3 3

    updating program update entire row even though it needs to update column1 and coumn3.

    Can any one advice me is this a right way to do?. I need a clear idea to convince my to how to proceed on this.

    Thanks for your valuable time on this.

  2. #2
    Join Date
    Sep 2011
    Pont l'Abbé, Brittany, France
    Provided Answers: 1
    Hi Sarav,

    before going into a long answer, which version of Informix engine is this ?

Tags for this Thread

Posting Permissions

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