Re: Impact on creating Indexes on a OLTP systems!

Posted in 1998

Arun Shastry — Thu, 10 Sep 1998 10:51:55 -0400 — source: Informix-list mailing list archive (1991-1998)

You cannot create an index on a table while it's being used or needs to be used, because index creation locks the table in exclusive mode and kills all sessions using that table. Once you create the indexes, you need to run update statistics for that to kick in. Your best bet is a weekend or off-peak hours for this kind of stuff. Good luck, Arun HARINATH VENKATA wrote: > Hi > > I would like to know the impact of creating indexes on a busy OLTP > environment on Informix 7.10 UC2 ON HP-UX 9.1 [ One CPU]. I need to run a > script across all identical databases[ 77 databases] that create indexes > .What factors do I need to consider to keep the engine performance, least > affected ? > > TIA , > Hari