Oninit cdi / Archive
Talk to an expert →

update statistics

Posted in 2000

Topics: General Discussion

David Kulkarni — — source: Informix-list mailing list archive (1991-1998)

I am new to informix and need to know how to run update statistics on a per table basis from the command line. TIA dnk61@yahoo.com __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

↪ replying to David Kulkarni
Chetan Anand — — source: Informix-list mailing list archive (1991-1998)

Try in isql / dbaccess Usage : dbaccess DATABASE_NAME << ! UPDATE STATISTICS [LOW|MEDIUM|HIGH] FOR TABLE <tablename>;! David Kulkarni wrote: > I am new to informix and need to know how to run > update > statistics on a per table basis from the command line. > > TIA > > dnk61@yahoo.com > __________________________________________________ > Do You Yahoo!? > Talk to your friends online with Yahoo! Messenger. > http://im.yahoo.com

Glossary