Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    30

    Unanswered: how to improve the performance for enable indexes

    I need to update a field in a table, there is an index on this field, which is not primary key.
    So i decide to deactivate this index, in order to perform faster update.

    seems, 2 millions records i can update around half an hour, it is ok, but when i try to enable this index, even i set pdqpriority 100, it still take too long time, any other configuration i should take into account?

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    if your version of IDS is 10.uc5 you can alter you table to RAW with index enabled... but caution, your updates will not be write in logical log. Your updates will be execute faster....

    "RAW tables do not support referential constraints, unique constraints, and rollback."
    read more about RAW tables here: http://publib.boulder.ibm.com/infoce...c/admin330.htm
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Oct 2005
    Posts
    30
    thank you, unluckily the version is below 10. but it is good to know.

Posting Permissions

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