Re: when to 'update statistics' ???

Leo_Chen@usc.com.tw wrote: > > Hi all: > if anyone knows when to do the 'update statistics' ? > Or, if there is any information (some ratios, for example) indicates > that the engine needs 'update statistics'?? > > leo If you have a very active tables (many inserts and delete), you should update statistics regularly when posible. One good thing to do if you are not familiar with the process is to read your release notes in the $INFORMIXDIR/release directory. These notes explain which level of update statistics to apply to a table or columns in order for the optimizer to work best. -- Jorge Torralba Intel Information Technology HF2-71 (503)696-4587 5200 NE Elum Yung Parkway Hillsboro, Or 97124 ===================================================== Any views or opinions expressed by me do not reflect those of Intel Corp.