Differences between Online 5 and 7

I have to write 4 o 5 remarks about the most relevant differences between Informix Online version 5.05 UC1 and Informix Online version 7.24. I know that one different is teh possibility about fragment tables, but I think there are more. Could anyone help me? Thanks in advance * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

jose cipres wrote: > > I have to write 4 o 5 remarks about the most relevant > differences between Informix Online version 5.05 UC1 and > Informix Online version 7.24. > > I know that one different is teh possibility about fragment > tables, but I think there are more. > > Could anyone help me? o Table fragmentation o Detached indexes o Index fragmentation o Multiple threads of execution o Parallel searching of fragmented tables and indexes o Reduced system overhead due to having a fixed pool of multithreaded oninit processes replacing the per-user sqlexec processes. o Improved throughput due to asynchronous I/O o Enterprise Replication and High Availability Replication o Improved archive utilities and improved ontape utility o Increased database size (5.0 max is about 150GB, 7.xx/9.xx is 2TB). o Increased table size (5.0 max is 32GB, 7.xx/9.xx 2TB) o Serious bug in tbtape in 5.xx versions earlier than 5.08) o Vastly improved optimizer which uses data histograms to make better decisions. o Advanced SQL support. o Optimizer hints, optimizer goal control (FIRST ROWS -vs- ALL ROWS optimization), OPTCOMPIND control of join method ....and on and on Art S. Kagel & Family kagel@erols.com