Re: Question on Update Statistics

Posted in 1997

Art S. Kagel — Mon, 10 Nov 1997 15:04:29 -0500 — source: Informix-list mailing list archive (1991-1998)

KPonn wrote: > > Hi > > If I want to run update statistics on busy tables, can I do the following: > > 1. select tabname,iswrites,isreads from sysptprof order by 1,2 > 2. Then look at indexes for each table > 3. Update statistics (high or medium) on that table or on column > > or > > Just do steps 1 and 3 > > or > > ??? Get dostats.ec from my submission to the IIUG software archives: http://www.iiug.org/members/memb_software/archive/utils_ak Art S. Kagel