update statics high

Posted in 2001

sudhakar — Sat, 03 Feb 2001 08:30:06 -0000 — source: Informix-list mailing list archive (1991-1998)

hello, when is Update statics High Run on a table.will u please tell men on what columns of a table Update statics High can be run.whether on a primary key column or columns heading the index or all columns of a table. bye.. sudhakar -- Posted via CNET Help.com http://www.help.com/

↪ replying to sudhakar

Art S. Kagel — Wed, 07 Feb 2001 03:14:42 -0500 — source: Informix-list mailing list archive (1991-1998)

If you run it at the table level, ie UPDATE STATISTICS HIGH ON table, ALL columns will have statistics generated at the high level and all indexes at the low level. Art S. Kagel sudhakar wrote: > > hello, > > when is Update statics High Run on a table.will u please tell men on what > columns of a table Update statics High can be run.whether on a primary key > column or columns heading the index or all columns of a table. > > bye.. > sudhakar > > -- > Posted via CNET Help.com > http://www.help.com/