Re: impacts of moving from informix 7.1 to 7.3 ?

David Samson wrote: > > Art S. Kagel <kagel@bloomberg.com> wrote in article > <355B278C.741B@bloomberg.com>... > > <snip> > > > Not to worry. IDS 7.3 is already out on Solaris/SPARK (indeed 7.30UC2 > > is due out next week with some minor bug fixes). Reports from users > > already using 7.30UC1 are that 7.3 is 25% -> 55% faster than 7.2 which > > was slightly faster than 7.1x in general and noticable faster at I/O > > than 7.1x. There are new features all but one of which are optional > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > <snip> > > Art, > > What new feature is not optional? Sub-query unrolling can not be disabled. So, as I explained, if you have a correlated sub-query, but do not have the indexes to support efficient execution of the resulting join after unrolling, your query may run more slowly than before. However, adding the missing indexes results in big speed improvements over the sub-query running under 7.2x. Art S. Kagel