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

u can use sql

disbale index on table ;
enable index on table;