Re: Finding pending in-place alters

Posted in 2006

Thomas J. Girsch — Sat, 04 Feb 2006 03:44:49 GMT — source: Usenet: comp.databases.informix

Rajib Sarkar wrote: > Attached is a script which does not use onchecks to find out pending > IPAs and also generates a script containing update statements for all > the tables having pending IPAs (the script is intelligent enough to not > choose any index columns for the update so that it does a sequential > scan of the table). > > HTH > Thanks, we'll test this. It looks perfect.