Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered: Disable/Enable Index in Informix

    Hi all,
    Anyone knows how to Enable/Disable index for Informix XPS 8.xx? I need to disable but not drop the index due to rebuilding the index for about 200,000,000 records would be very long. I need to Disable before performing any DML statement and then Enable after all the DML completed. Any idea?

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    Quote Originally Posted by nick_dbguy
    Hi all,
    Anyone knows how to Enable/Disable index for Informix XPS 8.xx? I need to disable but not drop the index due to rebuilding the index for about 200,000,000 records would be very long. I need to Disable before performing any DML statement and then Enable after all the DML completed. Any idea?
    http://publib.boulder.ibm.com/infoce...oc/sqls779.htm

    this is to IDS 10 , but i think this works in IDS 8 XPS...
    if not... look up on the manuals...
    http://www-306.ibm.com/software/data...ary/xps_8.html
    ________________________________________
    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
    Sep 2005
    Posts
    9
    u can use sql

    disbale index on table ;
    enable index on table;

Posting Permissions

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