Re: Advantages upgrading from Informix 4.xx to 6.xx

Posted in 1997

David Williams — Sat, 17 May 1997 09:58:45 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <NHR2BDATFhezEw1d@nickcol.demon.co.uk>, Nick Colthorpe <nickc@nickcol.demon.co.uk> writes >Can anyone tell me the advantages/disadvantages of upgrading from >Informix version 4.00 to 6.00. >We are using the Standard Engine running under SCO UNIX. > A better optimizer which can use data distributions. A new UPDATE STATISTICS samples the values in the column and stores how often values occur. It splits the range of values in the column into several ranges and stores how many rows are in each range of values for the column. International character support. These are the main two + it is the lateste version hence will be supported in the future whereas support for SE 4 will be phased out soon. -- David Williams