Rebuild indexes

Posted in 2006

Hendrick — 28 Mar 2006 14:26:17 -0800 — source: Usenet: comp.databases.informix

What is the method of rebuilding indexes in 9.4? Could you possible include some systax? Thanks in advance

↪ replying to Hendrick

Michael Schmid — Wed, 29 Mar 2006 12:22:45 +0200 — source: Usenet: comp.databases.informix

There are more than this option i use: ALTER FRAGMENT ON INDEX the_index_name INIT IN dbspace_name; Other people prefer the DROP/CREATE procedure to rebuild, but that can get nasty when you constraints etc.

↪ replying to Michael Schmid

Hendrick — 29 Mar 2006 12:27:29 -0800 — source: Usenet: comp.databases.informix

Thanks for your response. Do I do this for every index? There is three indexes within the same table. Also how do I go about updateing statistics on that table?