Re: what kind of update statistics

>From: "Tam McLaughlin" <tamm@scotlegal.com> >Reply-To: "Tam McLaughlin" <tamm@scotlegal.com> >To: informix-list@iiug.org >Subject: what kind of update statistics >Date: Fri, 21 Jan 2000 10:07:49 -0000 > >I have read the relevent pages in the online informix doc on update >statistics but >not sure which to run each night. >Our system is an OLTP one and IDS 7.30.UC2 on SCO unixware 7 we use RAID 5 >so i dont think we have to worry about distributions as no data >fragmentation. >With online 5 we ran plain and simple "update statistics". When I first >imported the >databases into the new version, I ran : > >"update statistics high for table "dba".agent_companies >(agcompid_ref,status_ref); > >for each table once. > >Now I only run "update statistics" each night. >Should i be doing "update statistics high/low/medium" or what ? > > Hi McLaughlin, I suggest you to do an update statistics low drop distributions and after that an upd stat high("index head"). Im my enviroment it was the best solution. bye. Christian Kondo system support specialist - SAP/Informix IBM Brazil ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com