Drop and Recreate Indexes

craig322 · Nov 30, 2004

Does anyone have a script that will dump the schema for all indexes in a database? I need to drop and rebuild all indexes in our databases.

TIA

olded · Nov 30, 2004

Check out this from the International Informix User Group software respository:

http://www.iiug.org/software/archive/save_idx

The whole iiug.org website is worth reviewing if you use informix.

Regards,

Ed

vpshriyan · Dec 4, 2004

Hi,

I would like to take attention over to FAQ area as it has a subject that deals with your query.

create & drop index definitions generator
faq179-4909

Regards,
Shriyan

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Drop and Recreate Indexes

craig322

MIS

olded

Programmer

vpshriyan

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor