RE: Whatcha' wanta have?????

Posted in 2004

Murray Wood (IList) — Tue, 10 Feb 2004 11:56:55 +1300 — source: Usenet: comp.databases.informix

Auto Update Statistics (i.e A set and forget option) To be done under some logical and meaningful circumstances - Change in number of rows by x% - Update of index columns by y% Optionally, this to be selectable so certain tables can be eliminated from the list of Auto Statistics (Default = All Tables). Optionally, this can be restricted to certain time of day intervals (Default = All Times). When corrupt column distributions are found, the table is flagged for update statistics and the distributions are ignored for this sql - rather than returning the Invalid Distributions error code to the application. MW sending to informix-list sending to informix-list