Re: Slow-running query with temp table on IDS 9.20

Posted in 2000

Neil Truby — Wed, 13 Sep 2000 08:08:07 +0100 — source: Informix-list mailing list archive (1991-1998)

smooth1 <smooth1@iclway.co.uk> wrote in message news:39bed022_2@news1.vip.uk.com... > > > Oh! 16 second down to 6 with IDS 2000!! > > Surely you can prepare and execute an update stats in the > VB application?? We do so in 4gl applications! Well, maybe we can. But really, the question is "Why do we have to?". This is just one of a number of differences in behaviour that we're finding in IDS 9.20. We're not using any of the extended functionality of IDS9.20, so really want it to behave as v7.x did (only faster!). But we keep getting bitten in the arse by query plans like this.